Transform a pivot in a table

[simotrab]

Hi community,

I have a problem of data management, and I hope to have put a clear title.

I have this kind of data: some seller, some products, and the quantity of product sold in two months.

seller  product  jan feb

a         aa         1     2

a         ab         2     3

b         ba         3     1

b         bb         3     8

here in a way Qlik-edible waty;

load*inline

[ seller, product, jan, feb

a,aa,1,2

a,ab,2,3

b,ba,3,1,

b,bb,3,8

];

I'd like to have the data in this way, using the load script:

seller  product  month quantity

a         aa          jan       1

a         aa          feb       2

a         ab         jan        2

a         ab         feb        3

b         ba         jan        3

b         bb         feb        1

b         ba         jan        3

b         bb         feb        8

how can I reach this?

Thanks for your time

[OmarBenSalem · Accepted solution]

transform it as follow

Crosstable (Month, Quantity, 2)  load * inline

[ seller, product, jan, feb

a,aa,1,2

a,ab,2,3

b,ba,3,1,

b,bb,3,8

];

[OmarBenSalem]

result :

[techvarun]

Use Cross Table

Crosstable (Month, Sales, 2) load*inline
[ seller, product, jan, feb
a,aa,1,2
a,ab,2,3
b,ba,3,1,
b,bb,3,8
];