Change block range into one column

C

cbart

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.
 
D

David McRitchie

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
 
B

Biff

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
 
Top