Multiple columns of data into one long column
 

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

Multiple columns of data into one long column
 

See
http://tinyurl.com/rt8dp
excel.misc, May 9, Combine Columns

Multiple columns of data into one long column
 

Thanks a lot Herbert, this works prefectly

B


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