Hi,
I am struggling to arrange my data without using two queries and subsequently merging. I have tried several combinations but it does not work.
I have the desired outcome in the attached file.
Please help.
Thanks,
Moavu
Hi Moavu,
The trick when you have nested headers is to Transpose the data first. Then you can promote headers and unpivot, before pivoting the Net Value and Sales Units again. See file attached.
Mynda
Hi Mynda,
Thanks I was missing the transpose step.
I have another conundrum of more than two rows to be unpivoted.
I have managed to do it using 4 merged queries but I am hoping there is a faster method with just one query?
I have attached the file.
Thanks,
Moavu
In future please start a new thread for a new question.
In the file attached you'll see the steps required in the query on the sheet called 'Mynda'.
Kind regards,
Mynda
