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.

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.

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.

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.