In Column B ( disregard Column A) and from Columns C to I, there is something si
ID: 3562535 • Letter: I
Question
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.
Help me!!! :-)
Explanation / Answer
No need for a macro.
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.
Hope this helps :)