Importing excel pivot table data

[#1]

Hi

I am trying to import data from excel. The data is only available in a pivot table (Countries in lines, years in columns). Is there an easy way to bring this into Qlikview or should I write macro in Excel to sort it out first?

[prabhu0505]

Hi Dewald,

This is not an anwser but a hint, try 'Enable transformation' tab in the File Wizard.

[#3]

Thanks, tried that but doesn't seem to work

[#4]

Hello,

check out the "Crosstable" prefix of a load statement.

Also the file wizard provides the crosstable option ... it is on the 3rd page of the dialog, AFTER the transformation page (See Crosstable Button).

hth,
Thilo