How to convert columns to rows in load script?

[Peony]

Hi All.

Please, need your advice how I can convert columns to rows using load script from this view

User	2019-Jan	2019-Feb
User 1	2,708	3,009
User 2	903	1,003
User 3	501	557

To this view

User	Date	Sum
User 1	2019-Jan	2,708
User 1	2019-Feb	3,009
User 2	2019-Jan	903
User 2	2019-Feb	1,003
User 3	2019-Jan	501
User 3	2019-Feb	557

[dplr-rn · Accepted solution]

Use cross table

CrossTable(Date,Value,1)
LOAD
User,
"2019-Jan",
"2019-Feb"
FROM [lib://Downloads/New Microsoft Excel Worksheet (3).xlsx]
(ooxml, embedded labels, table is Sheet2);

check below

https://community.qlik.com/t5/Qlik-Design-Blog/The-Crosstable-Load/ba-p/1468083

https://community.qlik.com/t5/Qlik-Design-Blog/The-Crosstable-Load/ba-p/1468083

[Peony]

Perfect!

Thank You much!