Easy way to take data from multiple columns

and put them into one column,

I have 4 columns of data. I need to take the data from the columns and combine them into one column. The data needs to go into the new column in this order: A1, B1, C1, D1, A2, B2, C2, D2, etc.

I there an easy way to do it?

Thanks!

Let me clarify a little more. That didn't do what I wanted it to. Basically I have a new column E. I want the data to go into one column.

so that I can go from (4 columns):
A1 B1 C1 D1
A2 B2 C2 D2

to this (one column):

A1
B1
C1
D1
A2
B2
C2
D2


I'm trying to find an easy way without just cutting and pasting each one or just using =A1 in E1, etc.

Hi,

Edit Copy
Edit PasteSpecial Transpose ...

HTH
Carim

That will work, thanks so much!!

Glad I could help a ... Tiger ...

Thanks for the feedback

Carim