Forum Discussion
Solved
Unpivot Table
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!
Maybe this article can be insightful: Working With Multiple Row Headers From Excel in Power Query — ehansalytics
That was the article I was looking for! Thanks!
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).
Maybe this article can be insightful: Working With Multiple Row Headers From Excel in Power Query — ehansalytics