Spreadsheet: 674721d1587995995-excel-large-data-to-summary-table-example-by-pq
Sheet: Sheet5

FROM | TO | SIDE | LEN | ITEM
685430 | 685440 | LHS |  | DLC | MISSING
685430 | 685440 | LHS |  | GSB | MISSING
685750 | 685790 | LHS |  | KERB-M | ADD BEFORE & AFTER
685750 | 685790 | LHS |  | KERB-S | ADD BEFORE & AFTER
686100 | 686200 | RHS |  | KERB-M | MISSING
686100 | 686200 | RHS |  | KERB-S | MISSING
686480 | 686500 | RHS |  | GSB | MISSING
686540 | 686550 | RHS |  | PQC | MISSING
686800 | 686830 | LHS |  | KERB-M | MISSING
686800 | 686830 | LHS |  | KERB-S | MISSING
687020 | 687040 | LHS |  | SG | MISSING
687020 | 687040 | LHS |  | GSB | MISSING
687000 | 687040 | LHS |  | KERB-M | MISSING
687000 | 687040 | LHS |  | KERB-S | MISSING
687190 | 687200 | LHS |  | KERB-M | MISSING
687190 | 687200 | LHS |  | KERB-S | MISSING
687370 | 687720 | LHS |  | KERB-M | MISSING
687370 | 687720 | LHS |  | KERB-S | MISSING
687610 | 687620 | RHS |  | PQC | MISSING
687640 | 687660 | RHS |  | DLC | OVERLAP
687900 | 687940 | RHS |  | DLC | OVERLAP
687900 | 687940 | RHS |  | PQC | OVERLAP
688280 | 688330 | LHS |  | GSB | OVERLAP
688280 | 688330 | LHS |  | DLC | OVERLAP
688280 | 688330 | LHS |  | PQC | OVERLAP
688280 | 688330 | LHS |  | KERB-M | OVERLAP
688280 | 688330 | LHS |  | KERB-S | OVERLAP
688220 | 688230 | RHS |  | SG | OVERLAP
688220 | 688880 | RHS |  | KERB-M | OVERLAP
688220 | 688880 | RHS |  | KERB-S | OVERLAP
685300 | 685720 | RHS |  | KERB-M | MISSING
685300 | 685720 | RHS |  | KERB-S | MISSING
689200 | 689240 | RHS |  | KERB-M | OVERLAP
689200 | 689240 | RHS |  | KERB-S | OVERLAP
689650 | 689780 | RHS |  | KERB-M | MISSING
689650 | 689780 | RHS |  | KERB-S | MISSING
689850 | 689870 | RHS |  | KERB-M | MISSING
689850 | 689870 | RHS |  | KERB-S | MISSING
689920 | 690000 | RHS |  | KERB-M | MISSING
689920 | 690000 | RHS |  | KERB-S | MISSING
690110 | 690120 | RHS |  | KERB-M | MISSING
690110 | 690120 | RHS |  | KERB-S | MISSING
690380 | 690400 | RHS |  | DLC | OVERLAP
690380 | 690410 | RHS |  | KERB-M | MISSING
690380 | 690410 | RHS |  | KERB-S | MISSING
690640 | 690650 | RHS |  | KERB-S | OVERLAP
691450 | 691460 | RHS |  | SG | OVERLAP
692580 | 692600 | LHS |  | SG | MISSING
692580 | 692600 | LHS |  | GSB | MISSING
692580 | 692600 | LHS |  | DLC | MISSING
692580 | 692600 | LHS |  | PQC | MISSING
692580 | 692600 | LHS |  | KERB-M | MISSING
692580 | 692600 | LHS |  | KERB-S | MISSING
694240 | 694350 | RHS |  | GSB | OVERLAP
694910 | 694930 | RHS |  | SG | MISSING
694910 | 694930 | RHS |  | GSB | MISSING
694910 | 694930 | RHS |  | KERB-M | OVERLAP
694910 | 694930 | RHS |  | KERB-S | OVERLAP
695580 | 695600 | RHS |  | DLC | MISSING
697440 | 697540 | RHS |  | SG | MISSING
697440 | 697540 | RHS |  | GSB | MISSING
697440 | 697540 | RHS |  | DLC | MISSING
697440 | 697540 | RHS |  | PQC | MISSING
699200 | 699380 | RHS |  | SG | MISSING
699200 | 699380 | RHS |  | GSB | MISSING
699200 | 699380 | RHS |  | DLC | MISSING
708580 | 708780 | LHS |  | SG | MISSING
708580 | 708780 | LHS |  | GSB | MISSING
708580 | 708780 | LHS |  | DLC | MISSING
709220 | 709240 | RHS |  | DLC | MISSING
709560 | 709580 | RHS |  | DLC | MISSING
709840 | 709860 | LHS |  | GSB | MISSING
710600 | 710620 | LHS |  | PQC | OVERLAP
714400 | 714660 | RHS |  | PQC | MISSING
714660 | 714870 | RHS |  | KERB-M | OVERLAP
714660 | 714870 | RHS |  | KERB-S | OVERLAP
714840 | 714870 | RHS |  | PQC | OVERLAP
715160 | 715800 | RHS |  | KERB-M | OVERLAP
715160 | 715800 | RHS |  | KERB-S | OVERLAP
716450 | 717000 | LHS |  | SG | MISSING
716450 | 717000 | RHS |  | SG | MISSING
716450 | 717000 | LHS |  | GSB | MISSING
716450 | 717000 | RHS |  | GSB | MISSING
718840 | 718850 | LHS |  | PQC | MISSING
718840 | 718850 | LHS |  | KERB-M | MISSING
718840 | 718850 | LHS |  | KERB-S | MISSING
719000 | 719030 | RHS |  | KERB-M | MISSING
719000 | 719030 | RHS |  | KERB-S | MISSING
719100 | 719180 | LHS |  | KERB-M | OVERLAP
719100 | 719180 | LHS |  | KERB-S | OVERLAP
721900 | 722100 | LHS |  | KERB-M | OVERLAP
721900 | 722100 | LHS |  | KERB-S | OVERLAP
722100 | 722140 | LHS |  | GSB | OVERLAP
722100 | 722140 | LHS |  | DLC | OVERLAP
722100 | 722140 | LHS |  | PQC | OVERLAP
722100 | 722140 | LHS |  | KERB-M | OVERLAP
722100 | 722140 | LHS |  | KERB-S | OVERLAP
722140 | 722200 | LHS |  | PQC | OVERLAP
722200 | 722860 | LHS |  | GSB | OVERLAP
722200 | 722320 | RHS |  | SG | OVERLAP
722200 | 722320 | RHS |  | GSB | OVERLAP
722210 | 722240 | RHS |  | DLC | OVERLAP
722230 | 722240 | RHS |  | PQC | OVERLAP
723480 | 723500 | RHS |  | PQC | MISSING
724500 | 725580 | LHS |  | PQC | OVERLAP
725600 | 726300 | LHS |  | SG | OVERLAP
728070 | 728080 | LHS |  | PQC | MISSING