I have a list that is 10,000+ lines long. I would like to downsize it by half
by adding another column. Is there an easier way besides all the cutting and
pasting?

There are some ideas here
http://www.mvps.org/dmcritchie/excel/snakecol.htm

or download ASAP utilities
http://www.asap-utilities.com/
and use format, paper saver

Barbara


"Lindsey" wrote in message
...
I have a list that is 10,000+ lines long. I would like to downsize it by
half
by adding another column. Is there an easier way besides all the cutting
and
pasting?

You only have to cut and paste once.

Select row 5001 then SHIFT + End + DownArrow to select to bottom.

Cut and paste those rows to a new column.

Or did you want some sort of snaking of data to take place?

1-50 in column A nd 51-100 in column B or similar?


Gord Dibben MS Excel MVP


On Thu, 27 Dec 2007 14:06:01 -0800, Lindsey
wrote:

I have a list that is 10,000+ lines long. I would like to downsize it by half
by adding another column. Is there an easier way besides all the cutting and
pasting?