Forum Discussion

gckcmc's avatar
gckcmc
Copper Contributor
Apr 10, 2020
Solved

Transposing data for better analysis

OK Excel junkies, I have been handed a large file of survey data.  I am trying to simplify the data to make my import into PBI easier, and my visualizations much more flexible.   I have data column...
BI & Data Analysis
excel
power bi
  • Abiola1's avatar
    Abiola1
    Apr 10, 2020

    gckcmc 

     

    Hello, all you need is Power Query to Unpivot  column

     

    You can watch the video below to see exactly how to unpivot using Power Query.

    https://www.youtube.com/watch?v=JMrfbv2h7p8

     

    If this answers suits you, kindly do accept as the Best Response

     

    Thanks

Abiola1's avatar
Abiola1
MVP
Apr 10, 2020

gckcmc 

 

Hello, all you need is Power Query to Unpivot  column

 

You can watch the video below to see exactly how to unpivot using Power Query.

https://www.youtube.com/watch?v=JMrfbv2h7p8

 

If this answers suits you, kindly do accept as the Best Response

 

Thanks

gckcmc's avatar
gckcmc
Copper Contributor
Apr 10, 2020

Abiola1 

Perfect, thanks!

  • Abiola1's avatar
    Abiola1
    MVP
    Apr 10, 2020
    Glad to help

Resources