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.
Hi Andreina, thank for the help, I'll say it helped me getting close to the output but not the exact.