Crosstable / Transpose Help

Question

Hi I have a dataset in excel similar to the following :

IDBlackRedBlueGreenOrangeYellowGrayLilacMagenta360Black        873    Orange    095 Red       921   Green     084Black        862   Green     874   Green     965   Green     668       Lilac 744         124       Lilac 988        Magenta

What I need to do is 'transpose' this table so I have a two columns of 'ID' and 'ColorGroup' which results in :

IDColorGroup360Black084Black095Red921Green862Green874Green965Green873Orange668Lilac124Lilac988Magenta

Can anyone advise on the ideal solution for this?

Much appreciated!

AmeliaG · Accepted Answer

Hi @fiorano,

Thanks for your question! I've attached a workflow which uses transpose in conjunction with a filter to achieve your desired results.

Let me know if you have any questions!

Amelia