Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose data from many horizontal rows into a single column
Thanks in advance for your suggestions...I have seen a similar request for
this exact issue using MS Access tables, but I need a solution in excel using Excel 2000/XP: I have data in the following format with 800 rows: row1: sally,b,c,d row2: john,f,g,h row3: david,j,k,l and I need to be able to put each row into a repeating single column: ie: column1: sally b c d john f g h david j k l Can anybody help with a formula or a simple (very simple) macro! Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose data from many horizontal rows into a single column
Here's one way ..
Assuming source data in cols A to D, from row1 down Put in E1: =OFFSET(A$1,INT((ROWS($1:1)-1)/4),MOD(ROWS($1:1)-1,4)) Copy E1 down until zeros appear, signalling exhaustion of data -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Tinkmodbod" wrote: Thanks in advance for your suggestions...I have seen a similar request for this exact issue using MS Access tables, but I need a solution in excel using Excel 2000/XP: I have data in the following format with 800 rows: row1: sally,b,c,d row2: john,f,g,h row3: david,j,k,l and I need to be able to put each row into a repeating single column: ie: column1: sally b c d john f g h david j k l Can anybody help with a formula or a simple (very simple) macro! Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose data from many horizontal rows into a single column
Thanks very much....works perfectly.
"Tinkmodbod" wrote: Thanks in advance for your suggestions...I have seen a similar request for this exact issue using MS Access tables, but I need a solution in excel using Excel 2000/XP: I have data in the following format with 800 rows: row1: sally,b,c,d row2: john,f,g,h row3: david,j,k,l and I need to be able to put each row into a repeating single column: ie: column1: sally b c d john f g h david j k l Can anybody help with a formula or a simple (very simple) macro! Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose data from many horizontal rows into a single column
welcome ..
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Tinkmodbod" wrote in message ... Thanks very much....works perfectly. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transpose Data from a column to several rows | Excel Worksheet Functions | |||
Transpose Horizontal? | Excel Discussion (Misc queries) | |||
transpose 3d cells to a column in single workbook | Excel Discussion (Misc queries) | |||
Transpose unique values in one column/mult. rows into a single row | Excel Worksheet Functions | |||
transpose a column into many rows | Excel Discussion (Misc queries) |