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.