Need help on Power Query to transpose data

[spycein]

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

I am looking for a result as follows:

Jan	Feb	Mar	April	May
100	200	300	400	500

Thanks in advance.

Best Regards,

 

[denzo36]

go to the Transform tab in PQ and hit Transpose - might need to also apply Use First Row as headers as you data doesn't have column headings

 

[spycein]

go to the Transform tab in PQ and hit Transpose - might need to also apply Use First Row as headers as you data doesn't have column headings

@denzo36 Thank you so much.

 

[denzo36]

No problem!