Merging the last column rows to first columns

[vidyasagar159]

Hello Everyone,

Can someone please help me in achieving the format table view? 

Actual Table:

Name	color	Category
Apple	Red	Fruit
Apple	green	Fruit
Grape	white	Fruit
Grape	black	Fruit
Onion	white	veggi
Onion	Red	veggi
Pepper	Red	Veggi
Pepper	green	veggi

Expected / Result:

Name	color
Fruit
Apple	Red
Apple	green
Grape	white
Grape	black
Veggi
Onion	white
Onion	Red
Pepper	Red
Pepper	green

[Vegar]

Try this

For each _cat in FieldValueList ('Category') 

Load '$(_cat)' as Name, 

NULL () as color 

Autogenerate (1);

CONCATENATE LOAD Name, color from Source

WHERE Category = '$(_cat)';

Next