Move Down Rows in Very Large Excel 2010 Spreadsheet In Column B ( disregard Colu

ID: 3562439 • Letter: M

Question

Move Down Rows in Very Large Excel 2010 Spreadsheet

In Column B (disregard Column A) and from Columns C to I, there is something similar to the following:

B1 blah C1 blah to I1 blah (that is C D E F G H I)

B2 blah C2 blah to I2 blah (that is C D E F G H I)

B3 blah C3 blah to I3 blah (that is C D E F G H I)

B4 blah C4 blah to I4 blah (that is C D E F G H I)

etc.

I need to move down C to I one row (but remaining in the same columns), so after the macro is run it looks as follows:

B1 blah

C2 blah to I2 blah (that is C D E F G H I)

B3 blah (formerly B2 etc.)

C4 blah to I4 blah (that is C D E F G H I)

B5 blah

C6 blah to I6 blah (that is C D E F G H I)

B7 blah

C8 blah to I8 blah (that is C D E F G H I)

etc.

As I said, the file is extremely large (about 35,000 rows), so it will take time to run, undoubtedly.

I would deeply appreciate your help in this matter.

Insert a new column A, and use this formula is A2 to A35000 (match your data)

=ROW()

Then copy column A and paste values over the formulas.

Next, copy all 35000 rows and paste the values below the existing data, so that you have 70000 rows.

In the first block of 35000 rows, delete values in columns D:J (what used to be C:I)

In the second block of 35000 rows, delete values in column C (what used to be B).

Then sort everything based on column A, delete column A, and you're done.

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.