Skip to main content
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

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

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 

2 Replies

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

talk is cheap, supply exceeds demand
Creator III
Creator III

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