J
Jim Radtke
Hello--
I trying to find an easier way for copying large amounts of data:
What I have:
Current my spreadsheets have information in six colums and each of them take
about about 60,000 rows of data:
I am using Excel 2007
For Instance:
A B C D E F G
H
201200 .05 301300 .06 401400
..07
201201 .06 301301 .08 401401
..05
and all the way down to row 60,000 (Give or Take)
So I want to take these six rows of data and condencse it into two rows of
data that has a total of 180,000 cells. (not a limitation in 2007)
Today, I go through and highlight the first cell, scroll all the way down
down down down. Then copy and paste those cells.
This can be a long and tedius process.
If there a better way?
I appreciate your help.
I trying to find an easier way for copying large amounts of data:
What I have:
Current my spreadsheets have information in six colums and each of them take
about about 60,000 rows of data:
I am using Excel 2007
For Instance:
A B C D E F G
H
201200 .05 301300 .06 401400
..07
201201 .06 301301 .08 401401
..05
and all the way down to row 60,000 (Give or Take)
So I want to take these six rows of data and condencse it into two rows of
data that has a total of 180,000 cells. (not a limitation in 2007)
Today, I go through and highlight the first cell, scroll all the way down
down down down. Then copy and paste those cells.
This can be a long and tedius process.
If there a better way?
I appreciate your help.