ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Move cells down (https://www.excelbanter.com/excel-programming/445155-move-cells-down.html)

gary

Move cells down
 
My spreadsheet has:

G T
001504798-2 001504798-2
001511777-5 001511777-5
001511905-4 001511905-4
001512678-2 001512678-2
001512678-2 001512697-9
001512678-2 001513196-6
001512678-2 001513504-1
001512678-2 001513842-6
001512697-9 001514491-5
001512697-9 001514725-7
001512697-9 001515239-8
001512697-9
001513196-6
001513504-1
001513504-1
001513504-1
001513842-6
001514491-5
001514491-5
001514491-5
001514491-5
001514491-5
001514725-7
001514725-7
001514725-7
001514725-7
001514725-7
001515239-8
001515239-8
001515239-8
001515239-8
001515239-8
001515312-0

How can I move the cells in COL T down until they are on the same row
as the matching cells in COL G so the result is:

G T
001504798-2 001504798-2
001511777-5 001511777-5
001511905-4 001511905-4
001512678-2 001512678-2
001512678-2
001512678-2
001512678-2
001512678-2
001512697-9 001512697-9
001512697-9
001512697-9
001512697-9
001513196-6 001513196-6
001513504-1 001513504-1
001513504-1
001513504-1
001513842-6 001513842-6
001514491-5 001514491-5
001514491-5
001514491-5
001514491-5
001514491-5
001514725-7 001514725-7
001514725-7
001514725-7
001514725-7
001514725-7
001515239-8 001515239-8
001515239-8
001515239-8
001515239-8
001515239-8


All times are GMT +1. The time now is 04:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com