Hi, all,

I have a table as follows:-

ID NAME CAT
1 Ris 100-Q
2 Ris 300-Q
3 Aj 100-Q
4 Gog 100-Q
5 Gog 200-I
6 Ras 200-Q
7 Van 300-Q
8 Van 300-I

I wish to convert it to the following format:-

ID NAME 100-Q 200-Q 300-Q 100-I 200-I 300-I
1 Ris 100 300
2 Aj 100
3 Gog 100 200-I
4 Ras 200
5 Van 300-Q 300-I

So that the user name becomes unique and the CAT column data is converted into rows headings and filled appropriately as shown.
For e.g. Ris has 2 rows in table 1 and in table2 in Row 1, Ris's two categories are shown appropriately and the need for the 2nd row is elinimated.
I hope I have been able to explain this sufficiently well.

Kindly help,
Thanks All !