Easy way to convert multiple columns into one

J

joe54345

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
 
B

Bryan Hessey

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.
 
J

joe54345

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.
 
B

Bryan Hessey

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.
 
B

Bryan Hessey

Well, no.

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

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

Are you asking to have your data converted from 5-row sets A1:B5 into
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.

--
 
Top