How to transpose a table wihtout generic load

[GLicks_DG]

Hi everyone, I'm new on qlikview and I could use some help.

Currently I'm trying to transpose a given table as the one below:

Month	Col A	Col B	Col C
Jan	10	20	30
Fev	5	10	15

My goal is to reach something like:

Month	Column	Value
Jan	Col A	10
Jan	Col B	20
Jan	Col C	30
Fev	Col A	5
Fev	Col B	10
Fev	Col C	15

I read some posts about using Generic Load to do so, but the actual table I'm working on has 12 rows and around 10000 columns so i won't be able to explicitly load everything.

Any suggestions? Thanks in advance!

[sunny_talwar · Accepted solution]

You don't need a generic load here, but The Crosstable Load

[dplr-rn]

generic load is the reverse of what you are trying to achieve. Like sunny said you need cross table load

[GLicks_DG]

It worked, appreciated!

The final script looked something like this:
OutputTable:
CrossTable(Column,Value)
LOAD * Resident InputTable

Anyhow, do you happen to know how CorssTable handles missing values?

Thank again

[sunny_talwar]

What do you mean? Are you saying if there is a cell with a null... would that be converted to a row? Yes it will be.... but if you don't need it, you can remove nulls from the resident load