Multiple columns of data into one long column

[beatrice25]

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

 

[Herbert Seidenberg]

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

 

[beatrice25]

Thanks a lot Herbert, this works prefectly

B