rotate data from x axis to y axis

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi everyone:

if i have some number at column and i want to switch all the numbers to
vertical in one times,how can i do this.

For example : i have 1 at A1 cell, 2 at Number at B1 cell and 3 at C1
cell, how can i switch/rotate all my data to A1/A2 and A3 cell?
 
Copy A1:C1 then select a cell out of the copied range and Paste
Special>Transpose>OK>Esc


Gord Dibben MS Excel MVP
 
Copy A1:C1, then right-click on A2 > Paste special > Transpose > OK.
Then delete row 1.
 
Back
Top