How to rotate a list of numbers?

[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

 

[Guest]

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.

 

[Steve Wolstenholme]

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

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

 

[Guest]

Thank everyone very much for suggestions
Eric

 

[Gord Dibben]

Steve

Just for info.

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


Gord Dibben MS Excel MVP