How to rotate a list of numbers?

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

Guest

There is a list of numbers under column A, and I would like to rotate this
list from vertical into horizontal axis, such as

A1 to A1
A2 to B1
A3 to C1
A4 to D1
....
Does anyone have any suggestions?
Thank in advance for any suggestions
Eric
 
Copy your column of number and then click EDIT, select PASTE SPECIAL and the
click the TRANSPOSE check box at the bottom of the dialog box.
 
There is a list of numbers under column A, and I would like to rotate this
list from vertical into horizontal axis, such as

A1 to A1
A2 to B1
A3 to C1
A4 to D1
...
Does anyone have any suggestions?
Thank in advance for any suggestions
Eric
Click to expand...

You can do that with Edit > Cut, Edit > Paste Special, check
transpose. You will probably need to paste into a different part of
your sheet.

Steve

--
Steve Wolstenholme Neural Planner Software Ltd

EasyNN-plus. The easy way to build neural networks.

http://www.easynn.com
 
Steve

Just for info.

Paste Special is not available with Cut cells. Just with Copied cells.


Gord Dibben MS Excel MVP
 
Back
Top