Spreadsheet: 95974d1295468589-combining-two-columns-into-a-single-columns-eliminating-blanks-forum-sample-18
Sheet: FINAL ORDER SORT

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COMBINING ROWS K AND L | COMBINING ROWS R AND S
 | 7 | 6 |  | SORT FROM OTHER 2 NUMBERS |  |  | 8 | 6 |  | SORT FROM OTHER 2 NUMBERS | DULPICATES |  |  | 9 | 5 |  | SORT FROM OTHER 2 NUMBERS | DULPICATES
 | NUM | TOTAL ORDERS |  |  |  |  | NUM | TOTAL ORDERS |  |  |  |  |  | NUM | TOTAL ORDERS
8 | 710 | 9 |  |  |  | 8 | 800 | 4 |  |  |  |  | 9 | 009 | 6
8 | 702 | 6 |  |  |  | 9 | 018 | 5 |  |  |  |  | 10 | 901 | 7
10 | 037 | 4 |  |  |  | 10 | 820 | 11 |  |  |  |  | 12 | 309 | 10
11 | 047 | 4 |  |  |  | 11 | 803 | 4 |  |  |  |  | 12 | 192 | 6
11 | 317 | 7 |  |  |  | 11 | 128 | 3 |  |  |  |  | 13 | 490 | 8
12 | 570 | 4 |  |  |  | 12 | 084 | 5 |  |  |  |  | 13 | 139 | 7
12 | 741 | 8 |  |  |  | 12 | 138 | 7 |  |  |  |  | 13 | 292 | 5
12 | 237 | 4 |  |  |  | 12 | 228 | 3 |  |  |  |  | 14 | 905 | 4
13 | 607 | 6 |  |  |  | 13 | 508 | 7 |  |  |  |  | 14 | 149 | 6
13 | 175 | 7 |  |  |  | 13 | 814 | 4 |  |  |  |  | 14 | 923 | 6
13 | 274 | 5 |  |  |  | 14 | 068 | 8 |  |  |  |  | 15 | 906 | 5
13 | 337 | 3 |  |  |  | 14 | 581 | 7 |  |  |  |  | 15 | 159 | 7
14 | 707 | 5 |  |  |  | 14 | 284 | 4 |  |  |  |  | 15 | 249 | 8
14 | 761 | 5 |  |  |  | 14 | 338 | 4 |  |  |  |  | 15 | 339 | 3
14 | 257 | 9 |  |  |  | 15 | 780 | 6 |  |  |  |  | 16 | 907 | 5
14 | 374 | 13 |  |  |  | 15 | 681 | 7 |  |  |  |  | 16 | 961 | 9
15 | 780 | 6 |  |  |  | 15 | 285 | 3 |  |  |  |  | 16 | 259 | 12
15 | 717 | 3 |  |  |  | 15 | 384 | 10 |  |  |  |  | 16 | 493 | 6
15 | 627 | 4 |  |  |  | 16 | 880 | 7 |  |  |  |  | 17 | 908 | 8
16 | 907 | 5 |  |  |  | 16 | 718 | 9 |  |  |  |  | 17 | 719 | 8
16 | 718 | 9 |  |  |  | 16 | 826 | 8 |  |  |  |  | 17 | 269 | 4
16 | 277 | 5 |  |  |  | 16 | 385 | 8 |  |  |  |  | 17 | 593 | 8
16 | 673 | 5 |  |  |  | 16 | 484 | 4 |  |  |  |  | 17 | 494 | 6
16 | 574 | 8 |  |  |  | 17 | 908 | 8 |  |  |  |  | 18 | 909 | 4
17 | 719 | 8 |  |  |  | 17 | 188 | 5 |  |  |  |  | 18 | 918 | 7
17 | 287 | 5 |  |  |  | 17 | 287 | 5 |  |  |  |  | 18 | 927 | 8
17 | 773 | 3 |  |  |  | 17 | 638 | 5 |  |  |  |  | 18 | 639 | 7
17 | 476 | 10 |  |  |  | 17 | 584 | 7 |  |  |  |  | 19 | 991 | 6
18 | 927 | 8 |  |  |  | 18 | 918 | 7 |  |  |  |  | 19 | 298 | 5
18 | 378 | 10 |  |  |  | 18 | 288 | 3 |  |  |  |  | 19 | 397 | 8
18 | 477 | 4 |  |  |  | 18 | 378 | 10 |  |  |  |  | 19 | 469 | 6
18 | 576 | 7 |  |  |  | 18 | 864 | 7 |  |  |  |  | 19 | 595 | 5
19 | 397 | 8 |  |  |  | 18 | 855 | 5 |  |  |  |  | 20 | 929 | 3
19 | 748 | 7 |  |  |  | 19 | 298 | 5 |  |  |  |  | 20 | 389 | 8
19 | 775 | 4 |  |  |  | 19 | 748 | 7 |  |  |  |  | 20 | 749 | 8
20 | 749 | 8 |  |  |  | 19 | 586 | 8 |  |  |  |  | 20 | 596 | 5
20 | 578 | 6 |  |  |  | 20 | 389 | 8 |  |  |  |  | 18 | 855 | 5
20 | 776 | 3 |  |  |  | 20 | 578 | 6 |  |  |  |  | 18 | 567 | 3
 |  |  |  |  |  | 19 | 595 | 3 |  |  |  |  | 19 | 595 | 3
 |  |  |  |  |  | 19 | 865 | 9 |  |  |  |  | 19 | 865 | 9
 |  |  |  |  |  | 19 | 577 | 3 |  |  |  |  | 19 | 577 | 3
 |  |  |  |  |  | 20 | 659 | 11 |  |  |  |  | 20 | 659 | 11
 |  |  |  |  |  | 20 | 578 | 10 |  |  |  |  | 20 | 578 | 10