Grouping of Data

[nnishapillai]

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.

 

[DavidP]

Use a Transpose tool and st the Adidas column as a key field.

[grossal · Accepted solution]

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

[nnishapillai]

That was awesome, Alex. It worked just perfect. Thanks a lot.