Partners,,,, russianxnxx

Convert Multiple Columns into Rows

Someone asked this interesting question on the PowerBI forum. Interesting enough that it deserves a blog post and could be relevant problem for a lot of people around

Consider this really messy data

Convert Multiple Columns into Rows 2

Against each continent, country and city we have 2 metrics revenue and quantity for multiple years


How would you transpose this in a tabular format ?

This is how the expected result should look like

Convert Multiple Columns into Rows 3

Please don’t say cut, copy and paste. You really need a heart to transform the data that way! I’ll post my solution soon!



Watch the Solution Video ..


    ⬇️ Pop in your Name & Email to get the file!



    Other Power Query Problems

    1. Rank Data based on 2 conditions
    2. Repeat the Row N Times



    Topics that I write about...