Color, Material#
Red,300
Red,301
Red,302
Red,309
Blue,401
Blue,308
Blue,306
for above information, i want to transpose to
Color,Material 1, Materail 2, Material 3, Material 4, Material 5
Red,300,301,302,309…
Blue,401,308,306…
How can i complete this transpose?
Use Group by node with aggregation options concatenate.
Could you share how to Configure? thanks!
It depend on how you load your data. If you load data as a string with coma when first use Cell Splitter. Then in Group by in groups tab add Color to Group Column(s) and in Manual Aggregation tab add Material# then in Aggregation (click to change) drop down column chose - Concatenate.