View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Steve Wolstenholme Steve Wolstenholme is offline
external usenet poster
 
Posts: 3
Default How to rotate a list of numbers?

On Fri, 22 Jun 2007 05:51:19 -0700, Eric
wrote:

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