Easy way to convert multiple columns into one

Is there a way I can do this without having to create a macro? I
looking for something inbetween so I don't have to cut and paste, thanks

In a spare column (say E), to join A B C and D, in E1 put

=A1&" "&B1&" "&C1&" "&D1

and formula drag that down the column as far as your data goes.

Hope this helps.

--

Originally Posted by [email protected]

Is there a way I can do this without having to create a macro? I
looking for something inbetween so I don't have to cut and paste, thanks

that actually converts all the rows into one cell. I'd like to take
each column and have it listed under the next. If there are 5 rows in
column A and 5 rows in column B I'd like the five rows of column B to
be listed right under the 5 rows of column A.

Well, no.

Formula copied down the worksheet it converts four columns into one column.

Columns are up-and-down, Rows are across.

Are you asking to have your data converted from 5-row sets A1:B5 into a one column set A1:A10 ?

Is there any data in columns C D & E etc?

Do you want columns A & B reorganised every 5 rows? ie A1:B5 to A1:A10, then A6:B10 to A11:A20, A11:B15 to A21:A30 etc?

If not, you will need to be more specific.

--

Originally Posted by [email protected]

that actually converts all the rows into one cell. I'd like to take
each column and have it listed under the next. If there are 5 rows in
column A and 5 rows in column B I'd like the five rows of column B to
be listed right under the 5 rows of column A.