multiple columns to single column

[beatrice25]

Does anyone know how to do this? I have lots of columns that need to be combined into a single column. Any ideas appreciated, I have looked in all the forums but cant quite find the right answer.

Thanks

Beatrice

[NBVC]

Try concatenating...

e.g.

=A1&B1&C1&etc...

Then you can copy this new column and Paste Special >> Values so that you can delete the old columns, if desired.

[beatrice25]

I need to preserve what's in the cells but I want about 50 columns of cells to be stacked one under the other into one tall column!

[beatrice25]

Sorry about the double posting but I realised I was in the wrong forum, I need vba code for this don't you think?

[shg]

I think you need to explain a little better, beatrice. Posting an example would probably help.

[beatrice25]

ok,
put all data in columns abc into column d
except i have many columns and about 300 rows

A B C (column)
1 4 7
2 5 8
3 6 9

change to

D (column)
1
2
3
4
5
6
7
8
9


I hope this explains it and thanks for any help

B25

[shg]

Maybe like this, beatrice. Untested.

Please Login or Register  to view this content.

[beatrice25]

no sorry the macro doesnt really do anything, thanks anyway

[shg]

Try this, b:

Please Login or Register  to view this content.