Switch from Columns <- Rows
 

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

Switch from Columns <- Rows
 

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
---
"Alain Dekker" wrote in message
...
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

Switch from Columns <- Rows
 

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

"Alain Dekker" wrote:

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

Switch from Columns <- Rows
 

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

"Alain Dekker" wrote in message
...
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

Switch from Columns <- Rows
 

Brilliant, thanks to you both :o)

Alain

"Eduardo" wrote in message
...
Hi,
Copy, then go to cell B1, paste special, transpose

"Alain Dekker" wrote:

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

Switch from Columns <- Rows
 

Thanks!

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Either the TRANSPOSE function or Copy/ Edit/ Paste Special/ Transpose.
--
David Biddulph

"Alain Dekker" wrote in message
...
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