Best Practice for Importing an Excel File

[#1]

Hello! Good Day,

I would like to ask what is the best practice when importing an Excel File with many headers.

Please do check the example given. I would like to come up with a clean table using the specific sample excel file.

Thank you and Regards,

Dona

[#2]

best way could be to transpose the table and do a crosstable load afterwards.

both is aviable in the qlikview load dialogue.

i had some crazy excel layouts in the past. but its possible to load most in qlikview.

i will be back with an example after lunch

[#3]

so, like i say earlier, transpose and crosstable came closer to a solution.

but the date has to be changed in the excel file. each collumn like water and food needs a date.

see example