Hi Katrina,

I cover this in lesson 4.17 of the Power Query course. Have you watched that tutorial yet?

Mynda

Hi Mynda,

I did watch this tutorial, particularly the part on Nested Column Headers. However, my case seems to be a little different because the headers are not nested, they are *wrapped* over two rows. I wasn't sure how to apply the techniques from your tutorial to the case at hand.

Further, the data itself is all wrapped over two rows.

Am I missing something that is shown in the tutorial video that could help me?

Hi Katrina,

If they're merged cells then once you format the data in an Excel table for loading to Power Query the rows will un-merge. Have you tried to load the data into Power Query?

Mynda

Hi Mynda,

The cells are not merged. 

Yes, I did turn the data into an Excel Table and then imported into Power Query. (see screenshot below).

I have unpivoted the data, but what I want is for Column 2 to be stacked BELOW Column 1.

In the same vein, every even numbered column should be stacked below the odd numbered column.

Hi Katrina,

Can you please upload a sample Excel file containing your before data and desired result. It's very difficult to help you from the screenshots.

Thanks,

Mynda

File containing raw data and a worksheet showing the desired result attached.

Hi Katrina,

You can just discard the second header row and rename the columns after cleaning the data. See attached.

Mynda

Hi Mynda,

Thank you! I took a look at the applied steps and saw that you tackled this by creating a conditional column on the end.

I'll familiarise myself with this.

Thank you so much!

Kind regards

Katrina