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

Easy way to convert multiple columns into one
 

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.

--


Wrote:
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


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=535482

Easy way to convert multiple columns into one
 

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.

Easy way to convert multiple columns into one
 

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.

--


Wrote:
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


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=535482

Easy way to convert multiple columns into one
 

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.

--

Wrote:
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.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=535482