Forum Discussion

coolshib's avatar
coolshib
Helper III
5 years ago
Solved

Need help on power query

Hello Everyone,

Need help to convert data from column wise to row wise.

 

My current data set is as follows:

Column 1Column 2
Jan100
Feb200
Mar300
April400
May500

 

I am looking for a result as follows:

JanFebMarAprilMay
100200300400500

 

Thanks in advance.

 

Best Regards,

Shib

Need Help
  • edhans's avatar
    edhans
    5 years ago

    For that, 2 steps coolshib 

    1. Transpose on the Transform ribbon.
    2. Use first rows to headers on the Home ribbon.

    Turns this:

    into this:

     

    Just make sure to set your data types when done from the 123/ABC to whatever it needs to be - whole number, number, etc.

3 Replies

  • edhans's avatar
    edhans
    Community Champion
    5 years ago

    For that, 2 steps coolshib 

    1. Transpose on the Transform ribbon.
    2. Use first rows to headers on the Home ribbon.

    Turns this:

    into this:

     

    Just make sure to set your data types when done from the 123/ABC to whatever it needs to be - whole number, number, etc.