Transpose data from many horizontal rows into a single column

[Guest]

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.

 

[Guest]

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

 

[Guest]

Thanks very much....works perfectly.

 

[Max]

welcome ..