Columnising data that has 2 rows of column headings

[CloudMonkey]

Hi,

I'm used to columnising data using the query editor transform tools but this one has me stuck 🙂

Row 3 has the calendar years

Row 5 has the calendar months

Column 1 has branch numbers

Cells B5:M8 have the budgeted volumes

My problem is that there are two rows of column headings (years and months) - please can you tell me how I should columnise this data in the query editor?

Many thanks

CM

[v-ljerr-msft · Accepted solution]

Hi @CloudMonkey,

Here is a good article about how to Unpivot Nested Headings With Power Query. Could you go to check if it helps in your scenario? 

Regards

[Greg_Deckler]

Can you post that data in as text that is able to be copied and pasted?