Hi,
I have this data set (screenshot attached).
Now it is in the form:
Adidas Green Blue Brown
I want it in the format
Adidas Green
Adidas Blue
Adidas Brown
Can someone pls help?
Thanks.
Solved! Go to Solution.
Use a Transpose tool and st the Adidas column as a key field.
HI @nnishapillai,
you can use the Transpose Tool.
And choose Brand as a key.
This results in:
I have added a Select Tool behind to remove the "Colors" columns.
Workflow attached. Let me know if it helps.
Alex
That was awesome, Alex. It worked just perfect. Thanks a lot.