Rotating/sorting data

A

Ali

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
 
J

Jason Morin

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

HTH
Jason
Atlanta, GA
 
F

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
 
F

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
 
Top