Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Move cells down
Col A
ASMT-NBR 008102510-5 PAYMT COLNBR 1 6068266 REDAMT ASMT-NBR 008102976-3 PAYMT COLNBR 1 22887 REDAMT 5 ASMT-NBR 010008486-3 PAYMT COLNBR 1 6102130 REDAMT ASMT-NBR 010008906-6 PAYMT COLNBR 1 415347 2 279003 REDAMT ASMT-NBR 010009090-1 PAYMT COLNBR 1 6102228 REDAMT ASMT-NBR 010009201-5 PAYMT COLNBR 1 415347 2 279006 ============= Col B 008102510-5 008102976-3 010008486-3 010008906-6 010009090-1 010009201-5 010009370-4 010009432-7 010009524-7 010009613-4 010009630-9 010013743-1 010013822-9 010015165-5 010015506-0 010016948-9 =================== How can I move the cells in col B down so they're on the same lines as the matching numbers (after "ASMNT-NBR") in col A? I want the result to look like this: Col A Col B ASMT-NBR 008102510-5 008102510-5 PAYMT COLNBR 1 6068266 REDAMT ASMT-NBR 008102976-3 008102976-3 PAYMT COLNBR 1 22887 REDAMT 5 ASMT-NBR 010008486-3 010008486-3 PAYMT COLNBR 1 6102130 REDAMT ASMT-NBR 010008906-6 010008906-6 PAYMT COLNBR 1 415347 2 279003 REDAMT ASMT-NBR 010009090-1 010009090-1 PAYMT COLNBR 1 6102228 REDAMT ASMT-NBR 010009201-5 010009201-5 PAYMT COLNBR 1 415347 2 279006 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can references (to cells being sorted) move with the cells? | Setting up and Configuration of Excel | |||
Move cells according to value | Excel Discussion (Misc queries) | |||
Sorting cells: a list behind the cells do not move with the cell | Excel Discussion (Misc queries) | |||
How do you move cells with a formula | Excel Worksheet Functions | |||
Move 2 cells to right | Excel Discussion (Misc queries) |