Moving data in a large cell range to one row

T

Todd

I have data in cell range A1:R34. All of the data needs
to be in column A. Instead of cutting and pasting each
row or column in the range, is there a way to move all of
this data quickly to column A? Thanks for the help.
 
F

Frank Kabel

Hi
and how do you want it to move into this column?. Best would be you
give an example
 
T

Todd

It really doesn't matter how it gets there as long as all
of the data gets to column A. For example the setup of
the data in my spreadsheet is like the followuing:

A B C D E F
G H I j K l
M N O P Q R

I would like for it to look like the following without
having to cut and paste:

A
B
C
D
E

You get the idea. Is this possible?
 
F

Frank Kabel

Hi
then enter the following on a separate sheet in cell A1:
=OFFSET('data_sheet'!$A$1,INT((ROW()-1)/18),MOD(ROW()-1,18)
and copy this down as far as needed. After this copy this column A and
insert it with 'Edit - Paste Special - values'
 
Top