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.

--


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

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.

--

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

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