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
Bookmarks