how to convert column headers to rows and rows to column values

[LloydM]

hi,

i have several spreadsheets containing daily inventory with each file containing the inventory for all the days of the month similar to the following:

item	1/1/2022	1/2/2022	1/3/2022	1/4/2022	1/5/2022	1/6/2022
a	100	0	0	0	0	0
a	100	200	0	0	0	0
a	100	200	300	0	0	0
b	50	0	0	0	0	0
b	50	75	0	0	0	0

would it be possible to convert the above table to the following format via load script?

item	date	qty
a	1/1/2022	100
a	1/2/2022	200
a	1/3/2022	300
b	1/1/2022	50
b	1/2/2022	75

would appreciate if anybody can help.

Thanks

[MarcoWedel · Accepted solution]

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

[LloydM]

Hi @MarcoWedel thanks this is great!!!!