LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Question about copying long rows of data

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.




--
Jim Radtke
Communication Alliance Partners
636-391-7738
MSN:
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
data linking/field matching/formula updating long question carol white Excel Discussion (Misc queries) 0 June 23rd 08 03:51 AM
Copying data between duplicated rows [email protected] Excel Worksheet Functions 2 April 14th 08 05:00 PM
Copying Columns of Data to Rows Walter Excel Discussion (Misc queries) 3 May 30th 07 05:01 PM
Retrieve multiple data rows data from a very long list and copy t mathew Excel Discussion (Misc queries) 1 September 13th 06 08:24 PM
Copying data without hidden rows. Cube Farmer Excel Worksheet Functions 2 April 27th 05 03:17 PM


All times are GMT +1. The time now is 10:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"