Partners filmexxx.link, sextotal.net, ahmedxnxx.com, https://xnxx1xvideo.com, russianxnxx
Home

Convert Multiple Columns in Rows

Posted on by Chandeep  -   

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 ..

 

    ⬇️ 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

     

     

    .       

    Automate repetitive data cleaning tasks using Power Query

    A comprehensive course to learn Power Query to automate all your mundane and repetitive data cleaning tasks in Excel or in Power BI

     

    DOWNLOAD THE COURSE OUTLINE    |    ENROLL IN THE COURSE

         


    Topics that I write about...



    Chandeep

    Welcome to Goodly! My name is Chandeep. On this blog I actively share my learning on practical use of Excel and Power BI. There is a ton of stuff that I have written in the last few years. I am sure you'll like browsing around. Please drop me a comment, in case you are interested in my training / consulting services. Thanks for being around Chandeep