Data Transformation in Load Script

[Anku]

Hi all,

I have a query related to Qliksense.

I want to convert below data, which I receive in excel (It's a pivot table output but I don't have the access to raw data) :

Row Labels	Jan	Feb	Mar	Apr	May	Jun	Jul
A	458	776	932	846	872	569	932
B	920	771	319	601	346	923	174
C	375	736	184	267	586	556	870
D	285	911	785	601	195	599	740
E	804	708	816	995	165	788	896
F	555	500	874	781	231	936	538
G	463	617	264	422	320	314	899
H	478	919	844	106	789	468	336
I	801	689	494	115	103	381	111
J	612	473	891	920	638	410	631

I want to convert it to below:

.

.

.

till Dec.

I tried reading solution on:

https://community.qlik.com/thread/112003

but content is not available,

then I went through generic load:

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

It was helpful but the output I am looking for is opposite of it.

Please suggest!

[Or]

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptP...

Crosstable and Generic Loads are opposites, so this should be what you're after.