Problem with import of a excel

[#1]

Hi

Can someone maybe help me out here and show me how I best import attaced excel.

I don´t get how I should do with the diffrent headers.

edit: the +/- don´t have to be imported, I will have qv to do that any way

/thanks!

[vgutkovsky]

You will need to crosstab it and then apply some additional transformations. See attached QVW.

Regards,

Vlad

[#3]

Thanks. Can´t reaaly get the 2nd and 3d step so i´t did´t work out on my complete sheet. I reattace the file with the complete data. Do you think you can help me again or tell me why it get wrong with the f12 header and higher.

[Gysbert_Wassenaar · Accepted solution]

See attached qvw, adapted for the complete set of months.

[#5]

Thanks!