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 1 Column 2 Jan 100 Feb 200 Mar 300 April 400 May 500 ...
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.

edhans's avatar
edhans
Community Champion
5 years ago

Glad to be of assistance coolshib