I have a large block range of numerical data in B1:E20. I need to move all
of the data in the range into one column, Column A. Tried Transpose but it
didn't work on a block range. Any other formulas I can try without copying
and pasting every single column? Thanks.

Question is ambiguous, what exactly do you want to do each time.
Are you trying to select a range of cells and to paste each non-empty cell found
left to right then next row in selection as separate cells into
another point as single cells down from another point in column A.

And I see you have formulas on top of whatever you want to do.

or do you want to cobine every thing on a row into cell A separated by
a space or other delimiter.
http://www.mvps.org/dmcritchie/excel/join.htm

Please use your first and last name in newsgroups.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"cbart" wrote in message ...
I have a large block range of numerical data in B1:E20. I need to move all
of the data in the range into one column, Column A. Tried Transpose but it
didn't work on a block range. Any other formulas I can try without copying
and pasting every single column? Thanks.

Hi!

Try this:

Enter this formula in A1 and copy down as needed:

=OFFSET($B$1,INT((ROWS($B$1:B1)-1)/4),MOD(ROWS($B$1:B1)-1,4))

Biff

"cbart" wrote in message
...
I have a large block range of numerical data in B1:E20. I need to move all
of the data in the range into one column, Column A. Tried Transpose but
it
didn't work on a block range. Any other formulas I can try without
copying
and pasting every single column? Thanks.

Thank you, Biff. You nailed it! It was the perfect solution. Thank you so
much!

"Biff" wrote:

Hi!

Try this:

Enter this formula in A1 and copy down as needed:

=OFFSET($B$1,INT((ROWS($B$1:B1)-1)/4),MOD(ROWS($B$1:B1)-1,4))

Biff

"cbart" wrote in message
...
I have a large block range of numerical data in B1:E20. I need to move all
of the data in the range into one column, Column A. Tried Transpose but
it
didn't work on a block range. Any other formulas I can try without
copying
and pasting every single column? Thanks.

You're welcome. Thanks for the feedback!

Biff

"cbart" wrote in message
...
Thank you, Biff. You nailed it! It was the perfect solution. Thank you
so
much!

"Biff" wrote:

Hi!

Try this:

Enter this formula in A1 and copy down as needed:

=OFFSET($B$1,INT((ROWS($B$1:B1)-1)/4),MOD(ROWS($B$1:B1)-1,4))

Biff

"cbart" wrote in message
...
I have a large block range of numerical data in B1:E20. I need to move
all
of the data in the range into one column, Column A. Tried Transpose
but
it
didn't work on a block range. Any other formulas I can try without
copying
and pasting every single column? Thanks.