Need help on power query

[coolshib]

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,

Shib

[edhans · Accepted solution]

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.

[coolshib]

@edhansThank you so much..

[edhans]

Glad to be of assistance @coolshib