Extracting data from one sheet to another

  • Thread starter Thread starter Hirsch
  • Start date Start date
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
 
Back
Top