Hi Pierre (macro guru),

Is there a way to do the opposite?

I would like to take many columns with varying amounts of rows and put them all into one column.

Example: Column B has 10 rows of text Column C has 5 rows of text and Column D has 15 rows of text.
What I would like to happen is: I select columns B, C, and D, press the magic button and they all go in to column A.
B followed by C followed by D and so on.

So Colunm A would end up with with 30 rows, B followed by C followed by D and so on.


Many thanks
Paul