software

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.
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: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;cbartquot; gt; wrote in message ...
gt; I have a large block range of numerical data in B1:E20. I need to move all
gt; of the data in the range into one column, Column A. Tried Transpose but it
gt; didn't work on a block range. Any other formulas I can try without copying
gt; 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

quot;cbartquot; gt; wrote in message
...
gt;I have a large block range of numerical data in B1:E20. I need to move all
gt; of the data in the range into one column, Column A. Tried Transpose but
gt; it
gt; didn't work on a block range. Any other formulas I can try without
gt; copying
gt; and pasting every single column? Thanks.
Thank you, Biff. You nailed it! It was the perfect solution. Thank you so
much!

quot;Biffquot; wrote:

gt; Hi!
gt;
gt; Try this:
gt;
gt; Enter this formula in A1 and copy down as needed:
gt;
gt; =OFFSET($B$1,INT((ROWS($B$1:B1)-1)/4),MOD(ROWS($B$1:B1)-1,4))
gt;
gt; Biff
gt;
gt; quot;cbartquot; gt; wrote in message
gt; ...
gt; gt;I have a large block range of numerical data in B1:E20. I need to move all
gt; gt; of the data in the range into one column, Column A. Tried Transpose but
gt; gt; it
gt; gt; didn't work on a block range. Any other formulas I can try without
gt; gt; copying
gt; gt; and pasting every single column? Thanks.
gt;
gt;
gt;

You're welcome. Thanks for the feedback!

Biff

quot;cbartquot; gt; wrote in message
...
gt; Thank you, Biff. You nailed it! It was the perfect solution. Thank you
gt; so
gt; much!
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; Hi!
gt;gt;
gt;gt; Try this:
gt;gt;
gt;gt; Enter this formula in A1 and copy down as needed:
gt;gt;
gt;gt; =OFFSET($B$1,INT((ROWS($B$1:B1)-1)/4),MOD(ROWS($B$1:B1)-1,4))
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;cbartquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I have a large block range of numerical data in B1:E20. I need to move
gt;gt; gt;all
gt;gt; gt; of the data in the range into one column, Column A. Tried Transpose
gt;gt; gt; but
gt;gt; gt; it
gt;gt; gt; didn't work on a block range. Any other formulas I can try without
gt;gt; gt; copying
gt;gt; gt; and pasting every single column? Thanks.
gt;gt;
gt;gt;
gt;gt;