Convert column data into row headings to get the desired table.

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 !

Hi Sambo kid,

Thanks for the reply,

However, that will nor produce the final table, i think. I need to get rid of the duplicates in table 1. Also I need that the correct values of categories be placed in the correct columns as shown in table 2.

A simple transpose would only give me the headings, not generate the values or delete the duplicates.

What do you think ?

Thanks loads.