Extracting data from one sheet to another

H

Hirsch

I have a speadsheet with 390 rows and 80 columns. For each column, I
wish to copy a range of cells and place them in rows so I can create a
separate table for each item represented by the column.

For instance, I would like to take the data from the range B10:B15 and
place that into a range A1:E1, and then data from range C10:C15 and
place into a range G1:K1, D10:D15 into I1:M1 and then B16:B21 into
A2:E2, C16:C21 into G2:K2, etc, etc, etc

I could do this manually, but it could take a while. I was wondering
if there was an easier way to do this.

Any help would be greatly appreciated.

Thanks

Hirsch
 

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

PLEASE HELP TO MATCH ALL SHEET AND THEN MERGE, 1
Excel Help to copy information from one row at a time to another sheet 1
extracting data from one workbook to another 2
Payment calculation 1
macro to find data from one sheet & copy in another sheet 6
Format linked workbook cells (updated) 2
copy data from 1 sheet to other sheet. 1
Pulling data from one sheet to another 1

Top