Crosstable from excel with multiple headerline

[#1]

I got an excel file with the format as I attach. I have to load that kind of excel file into Qlikview so can be analyzed.

Got headache with that kind of file and need your help [:(]

[#2]

Did you ever get a response? I have a similar problem, 2 years later.

How do I write an efficient script that pulls multiple dimensions into a cross table, separately:

Customer        ID            Region                 Jan Cost        Jan Volume            Feb Cost           Feb Volume

I'd like to have cost and volume broken out as separate fields. Any advice would be much appreciated.

Right now the only way I can think of is to load the same raw data file twice, and comment out the cost or volume fields in each one. This obviously results in inefficiencies when loading, and a syn-riddled data model.

[Gysbert_Wassenaar]

See attached files for an example.

[#4]

Thanks! Was hoping for a more elegant solution than this, especially since this problem appears to have been making the rounds on Qlikview forums for some time now. Does anyone have a simpler solution?