Hi Guys,
Does anyone know how to do a macro loop to take a variable number of
columns of data (each of various length) and turn it into one column of
continuous data
ie stack one column under the other with the left column being at the
top and the next column under it etc
eg

Before (3 columns)

1a5
2st
wx4
2 5
3

After
1 (column 1 start)
2
w
2
3 (column 1 end)
a (column 2 start)
s
x (column 2 end)
5 (column 3 start)
t
4
5 (column 3 end)


Any help greatly appreciated

B:)


--
beatrice25
------------------------------------------------------------------------
beatrice25's Profile: http://www.excelforum.com/member.php...o&userid=34505
View this thread: http://www.excelforum.com/showthread...hreadid=544005