Transpose the row data into multiple columns

[Mukesh_s]

Hi, I want to transfer the row data into columns as per the unique value. Below is the data that I have

ID	Date	Rating
1	1/1/2023	A
1	2/1/2023	B
1	3/1/2023	C
2	1/1/2023	D
2	2/1/2023	E
2	3/1/2023	F

I want to transfer this data as below table.  Unique date fields are divided as multiple columns and the ratings of each period displayed as per the ID. 

ID	1/1/2023	2/1/2023	3/1/2023
1	A	B	C
2	D	E	F

Thanks in advance.

[ogster1974]

In the back end using a generic load will let you convert your data model.

https://help.qlik.com/en-US/sense/February2023/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPref...

Or in the front end use a pivot table chart.

[Vegar]

This is an good blogpost by HIC about the generic load. It's 9 years old with an QlikView focus, but but still relevant today and for Qlik Sense.

https://community.qlik.com/t5/Design/The-Generic-Load/ba-p/1473470