i want to change one record from one column to another column

[manoj217]

Hi all , any one please help me on below requirement, your help is greatly appreciated.

id value may have more duplicate values it need to add the new columns like HD1,2,3,4--etc and below want to show their respected values on it.

i want to show this data in a straight table 

[Gysbert_Wassenaar]

Don't change your data model. Use a pivot table object in the front end to show the data in this way.

[manoj217]

Hi,
Thanks for your reply.
I have tried pivot table it will change values to column names in pivot, I don't want in that manner.
I want if I have more records for the same value in another column that I want to show in a different column. But the duplicates are dynamic