Move cells down

G

gary

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
 

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

Move cells down 2
Arriving at totals 2
Paragraph numbering in Word 1
Gears 14
Compute percentage 1
Compute percentages 2
Removing Sequential Numbers 5
Move cells down to match cells 0

Top