Cut/paste data from columns to another column

[mlarson]

Hi all, having a hard time figuring this one out. Hope you can help.

I would like for the data in all columns to be cut and then pasted into one column (column A, which is currently blank). I have data (about 30-55 rows each) in 1100 columns.

Data currently starts in column B. So, column B data would be cut and pasted into column A, then column C data cut and pasted at end of column A (under former-column B data), then column D data cut and pasted at end of Column A (under former-column C data), etc.

Is there a way to do this without VBA, by chance?

Thanks in advance for your help!

 

[footoo]

Is there a way to do this without VBA, by chance?

 

[mlarson]

Thank you so much, that worked perfectly!