Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
To handle multiple header rows, see here for inspiration: multi_header_pivot_import.qvw
You have to normalize that table usign crosstable function
I think we can try that way if possible
To handle multiple header rows, see here for inspiration: multi_header_pivot_import.qvw
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.