Moving data in a large cell range to one row

  • Thread starter Thread starter Todd
  • Start date Start date
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.
 
Hi
and how do you want it to move into this column?. Best would be you
give an example
 
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?
 
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'
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I move data from a row range to a column range 4
Excel Help to copy information from one row at a time to another sheet 1
Moving a bunch of data 1
When a cell is selected, move to a different cell 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
pasting with filter results into sequentual cells not same row? 1
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
moving all data to cell a1 4

Back
Top