This Macro or VBA procedure would:
1. Copy Row Q9:CA9 down to equal the number of rows in Column A that contains data.
2. Go to selection B9:C9 and copy to Z9:AA9. (After this, no more changes to B9:C9)
3. Go to selection D9:E9 and copy to AB9:AC9.
4. Move down to selection D10:E10 and copy to AB10:AC10
5. Continue copying the two cells in D and E columns to the AB and AC columns to the last row containing data in D and E Columns.
6. End
1. Copy Row Q9:CA9 down to equal the number of rows in Column A that contains data.
2. Go to selection B9:C9 and copy to Z9:AA9. (After this, no more changes to B9:C9)
3. Go to selection D9:E9 and copy to AB9:AC9.
4. Move down to selection D10:E10 and copy to AB10:AC10
5. Continue copying the two cells in D and E columns to the AB and AC columns to the last row containing data in D and E Columns.
6. End