How do I double the column data?

  • Thread starter Thread starter Lindsey
  • Start date Start date
L

Lindsey

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
 
You must log in or register to reply here.

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

How do I get data in several columns to appear all in one column? 2
SOLVER does not iterate / work 4
VBA - retrieve data on last create named range from previous inserted named range 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
how do I excel 0
combining two columns of data 3
How do I take information in 1 column to make column headings? 1
Cutting and Pasting with spaces 1

Back
Top