Switch from Columns <-> Rows

[Alain Dekker]

If I have a column of data:

1
2
3
4
5
etc

and I want to convert that into a row of data (transpose it):

1 2 3 4 5 etc

is there an Excel function to do this easily? I'm using Excel 97 SR-1.
Thanks,
Alain

 

[Max]

One way
Assume the source col data is in A1:A5
Put in say, C1: =INDEX($A$1:$A$5,COLUMNS($A:A))
Copy across to G1
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik

 

[Eduardo]

Hi,
Copy, then go to cell B1, paste special, transpose

 

[David Biddulph]

Either the TRANSPOSE function or Copy/ Edit/ Paste Special/ Transpose.

 

[Alain Dekker]

Brilliant, thanks to you both )

Alain

Hi,
Copy, then go to cell B1, paste special, transpose

 

[Alain Dekker]

Thanks!

Either the TRANSPOSE function or Copy/ Edit/ Paste Special/ Transpose.