Cross Tab -Transposing Data

Question

Hi All, I have a input table attached is the image and I want the output like output shown in attached image.

I tried cross tab and concatenated the data by grouping on Col A-ID and Col B-ID. But It is picking only first record against each instead of all. Please suggest.

Output.jpg

Input.jpg

davidskaife · Answer

Hi @AJuliet

I've replicated what @Andreina suggested and the results are coming through the same with one difference; you can't have columns with the same name:

New Workflow1.yxmd

AJuliet · Answer

Hi Andreina, thank for the help, I'll say it helped me getting close to the output but not the exact.

Andreina · Answer

Hello @AJuliet ,

Using a Filter and Append tool and I get the ouput table:

Hope it helps!

Andreina