Advanced transformation of XLS

[#1]

Hi,

I have problem transforming xls in attach (ETL Example.xlsx) into suitable form for import in QlikView. I found two parts most challenging:

• 2012 cell: I dont know how to deal with it
• fact that first 4 columns are fixed: if it was only one I could solve that problem using transpose > fill value > and then crosstable. But this way I get "multiple label rows"

Thank you in advance.

Milan

[#2]

Lil strange situation, but after couple of hours I have the answer

You do same thing as I described in second cue, and afterwards you left join other 3 fixed columns...

Additional explanation is available ofc if anyone needs.

Regards,

Milan