Working With Source Data With Multiple Data

[ngrunoz]

Hi

I have source data in excel that has got multiple header which I want to extract. How best can I transform it. Find attached.

[micheledenardi]

You have to normalize that table usign crosstable function

[ngrunoz]

I think we can try that way if possible

[Peter_Cammaert · Accepted solution]

To handle multiple header rows, see here for inspiration: multi_header_pivot_import.qvw

[ngrunoz]

I am failing to follow. please may you assist.  The other challenge I have is the number of columns on the 3 levels of headers differ for each section which is different from a normal pivot.