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!

DOWNLOAD THE EXCEL PROBLEM HERE

 

Watch the Solution Video ..

 

DOWNLOAD THE SOLVED FILE

 

 

Other Power Query Problems

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

 

 



Topics that I write about...






Download Smart Ebooks on
Excel and Power BI