Rotating/sorting data

[Guest]

Hi everyone
a bit of prob..im trying to do this
Ja
Fe
Marc

in to this orde
Jan Feb March Apri

can anyone tel me how to do it?
Cheers

 

[Jason Morin]

Copy the range, select a new cell, and do Edit > Paste
Special > Transpose.

HTH
Jason
Atlanta, GA

 

[Frank Kabel]

Hi Ali
one way: if your original data is in column A and you want to get it in
row 1 on a separate sheet (starting in A1) enter the following in A1 on
your target sheet:
=INDIRECT('source_sheet'!A" & COLUMN())
copy this to the left

Frank

 

[Frank Kabel]

And as an addition if you only want to copy the data: Copy the source
range and goto 'Edit - Paste Special'. Choose 'Transpose'

Frank