Data Transformation in Load Script

[Coldie]

Hi,

I need to load a large Excel-table into Qlikview. The table looks something like this:

I would like to create a table in Qlikview that looks like this:

Can this be achieved using data transformation? What would the script look like?

Thanks

Peter

[sushil353 · Accepted solution]

Hi,

See if this help you:

Multiple header in the excel