Unpivot Table

[wdvro]

Hello, 

I have a excel table that looks like this (simplified):

How can I transform it so it looks like this in Power BI:

Thanks in advance! 

[marcelsmaglhaes · Accepted solution]

Maybe this article can be insightful: Working With Multiple Row Headers From Excel in Power Query — ehansalytics

[marcelsmaglhaes]

Hey @wdvro !

In Power Query Editor you can choose the Unpivot Column function (Unpivot columns - Power Query | Microsoft Learn).

If this post helps, please mark as solved.

Regards,
Marcel

[wdvro]

Hey @marcelsmaglhaes , thanks for the reply.

I'm aware of this function. However, I am struggling with the fact that when loading into Power BI, my column titles are on both the 1st (gender, education, age) and 2nd rows (male, female, other, low, medium, high, 0-20, 20-40, 40-60). 

[marcelsmaglhaes · Accepted solution]

Maybe this article can be insightful: Working With Multiple Row Headers From Excel in Power Query — ehansalytics

[wdvro · Accepted solution]

That was the article I was looking for! Thanks!