Rotating/sorting data

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

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
 
Copy the range, select a new cell, and do Edit > Paste
Special > Transpose.

HTH
Jason
Atlanta, GA
 
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
 
And as an addition if you only want to copy the data: Copy the source
range and goto 'Edit - Paste Special'. Choose 'Transpose'

Frank
 
Back
Top