Cross Tab -Transposing Data

[AJuliet]

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.

[Andreina]

Hello @AJuliet ,

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

Hope it helps!

Andreina

[AJuliet]

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

[davidskaife]

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: