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

FROM | TO | SIDE | LEN | ITEM
681000 | 682600 | LHS |  | GSB | REMOVE
681000 | 682600 | RHS |  | GSB | REMOVE
683660 | 683700 | LHS |  | GSB | OVERLAP
685430 | 685440 | LHS |  | DLC | MISSING
685300 | 685720 | RHS |  | KERB-M | MISSING
685300 | 685720 | RHS |  | KERB-S | MISSING
685480 | 685750 | RHS |  | KERB-M | MISSING
685480 | 685750 | RHS |  | KERB-S | MISSING
685790 | 686100 | LHS |  | KERB-M | MISSING
685790 | 686100 | LHS |  | KERB-S | MISSING
686100 | 686200 | RHS |  | KERB-M | MISSING
686100 | 686200 | RHS |  | KERB-S | MISSING
686540 | 686550 | RHS |  | PQC | MISSING
686800 | 686830 | LHS |  | KERB-M | MISSING
686800 | 686830 | LHS |  | KERB-S | MISSING
686840 | 687560 | RHS |  | KERB-M | MISSING
686840 | 687560 | RHS |  | KERB-S | MISSING
687190 | 687200 | LHS |  | KERB-M | MISSING
687190 | 687200 | LHS |  | KERB-S | MISSING
687380 | 687720 | LHS |  | KERB-M | MISSING
687380 | 687720 | LHS |  | KERB-S | MISSING
687610 | 687620 | RHS |  | PQC | MISSING
687640 | 687660 | RHS |  | DLC | OVERLAP
687700 | 687750 | RHS |  | GSB | OVERLAP
687900 | 687940 | RHS |  | DLC | OVERLAP
687900 | 687940 | RHS |  | PQC | OVERLAP
688220 | 688230 | RHS |  | SG | OVERLAP
688220 | 688230 | RHS |  | GSB | OVERLAP
688220 | 688880 | RHS |  | KERB-M | OVERLAP
688220 | 688880 | RHS |  | KERB-S | OVERLAP
688260 | 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
689200 | 689240 | RHS |  | KERB-M | OVERLAP
689200 | 689240 | RHS |  | KERB-S | OVERLAP
691450 | 691460 | RHS |  | SG | OVERLAP
691450 | 691460 | RHS |  | GSB | OVERLAP
691150 | 691460 | RHS |  | DLC | MISSING
691150 | 691460 | RHS |  | PQC | MISSING
691150 | 691540 | LHS |  | DLC | MISSING
691150 | 691540 | LHS |  | PQC | MISSING
693320 | 693560 | RHS |  | GSB | OVERLAP
693500 | 693600 | LHS |  | GSB | OVERLAP
693600 | 694260 | LHS |  | DLC | MISSING
693600 | 694260 | LHS |  | PQC | MISSING
693910 | 694200 | RHS |  | SG | REMOVE
693910 | 694200 | RHS |  | GSB | REMOVE
694260 | 694300 | LHS |  | GSB | OVERLAP
694910 | 694930 | RHS |  | SG | MISSING
694910 | 694930 | RHS |  | GSB | MISSING
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
698400 | 698600 | RHS |  | GSB | OVERLAP
697460 | 698600 | LHS |  | SG | MISSING
697460 | 698600 | LHS |  | GSB | MISSING
697460 | 698600 | LHS |  | DLC | MISSING
697460 | 698600 | LHS |  | PQC | MISSING
699200 | 699380 | RHS |  | SG | MISSING
699200 | 699380 | RHS |  | GSB | MISSING
699200 | 699380 | RHS |  | DLC | MISSING
707680 | 707800 | LHS |  | GSB | OVERLAP
708580 | 708780 | LHS |  | SG | MISSING
708580 | 708780 | LHS |  | GSB | MISSING
708580 | 708780 | LHS |  | DLC | MISSING
709100 | 709220 | RHS |  | GSB | OVERLAP
709220 | 709240 | RHS |  | DLC | MISSING
709560 | 709600 | RHS |  | DLC | MISSING
710600 | 710620 | LHS |  | PQC | OVERLAP
710700 | 710730 | LHS |  | GSB | OVERLAP
716450 | 717000 | LHS |  | SG | MISSING
716450 | 717000 | LHS |  | GSB | MISSING
716450 | 717000 | RHS |  | SG | MISSING
716450 | 717000 | RHS |  | GSB | MISSING
721900 | 722140 | LHS |  | KERB-M | OVERLAP
721900 | 722140 | LHS |  | KERB-S | OVERLAP
722100 | 722140 | LHS |  | GSB | OVERLAP
722100 | 722140 | LHS |  | DLC | OVERLAP
722100 | 722200 | LHS |  | PQC | OVERLAP
722200 | 722320 | RHS |  | SG | OVERLAP
722200 | 722320 | RHS |  | GSB | OVERLAP
722210 | 722240 | RHS |  | DLC | OVERLAP
722230 | 722240 | RHS |  | PQC | OVERLAP
723500 | 723700 | LHS |  | GSB | OVERLAP
723950 | 724300 | RHS |  | SG | REMOVE
723950 | 724300 | RHS |  | GSB | REMOVE
724070 | 724300 | LHS |  | SG | REMOVE
724070 | 724300 | LHS |  | GSB | REMOVE
724300 | 724350 | LHS |  | GSB | OVERLAP
724500 | 725580 | LHS |  | PQC | OVERLAP
726300 | 726350 | RHS |  | GSB | OVERLAP
727300 | 727400 | RHS |  | GSB | OVERLAP
727800 | 727900 | RHS |  | GSB | OVERLAP