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