Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
+++Switch Rows & Columns | Excel Worksheet Functions | |||
How to switch position of columns and rows respectively? | Excel Worksheet Functions | |||
How to switch position of columns and rows respectively? | Excel Worksheet Functions | |||
switch rows and columns | New Users to Excel | |||
Switch Rows and Columns | Excel Discussion (Misc queries) |