From Column to Row

[shlomek12]

I have a lot of Number's like this , 1 column after column.

12.00 80.00 95.00 25.00

I want to make it like this Row after Row

12.00
80.00
95.00
25.00

Thanks in advance for your help

 

[KMB]

Highlight the data selection you want and copy. Then select the cell that you would like the column to start.

Right click -> Paste Special -> Transpose -> OK

That should take care of it.

 

[shlomek12]

Thank you for your Quick Respond