Scenario

[bohravanraj]

Hi Guys,

I am Having a scenario where i have data in following Format

Plant	Material	Status
A	111	Moving
B	111	Moving
C	111	Moving
D	111	Non Moving
E	111	Slow Moving

and Have to acheive below table in Front End.

Plant	Material	Status	Non Moving Status in other Plant	Non Moving Plant in other Plant	Slow Moving Status in other Plant	Slow Moving Plant in other Plant
A	111	Moving	Non Moving	D	Slow Moving	E
B	111	Moving	Non Moving	D	Slow Moving	E
C	111	Moving	Non Moving	D	Slow Moving	E
D	111	Non Moving	-	-	Slow Moving	E
E	111	Slow Moving	Non Moving	D	-	-

Thanks in Advance.