Spreadsheet: 878891d1726206541-need-an-output-table-based-on-two-input-tables-sample-1-
Sheet: Sheet1

Table-1 |  |  |  | Table-2 |  |  |  | Table-3 |  |  |  |  | Table-4
From | To | TCS Type |  | From | To | Layer |  | From | To | Layer | TCS |  | From | To | Layer | TCS
585820 | 586200 | TCS-1 |  | 585820 | 586170 | DBM |  | 585820 | 586170 | DBM | TCS-1
586200 | 586215 | TCS-6C |  | 586170 | 586210 | GSB |  |  | 586200 | GSB | TCS-1
586215 | 586385 | TCS-6C |  | 586210 | 587700 |  |  |  | 586210 | GSB | TCS-6C
586385 | 587010 | TCS-6C |  | 587700 | 587810 | GSB |  |  | 586560 |  | TCS-6C
587010 | 587100 | TCS-6C |  | 587810 | 587840 |  |  |  | 587100 |  | TCS-6C
587100 | 588700 | TCS-4 |  | 587840 | 588200 | GSB |  |  | 587500 |  | TCS-4
588700 | 589620 | TCS-6C |  | 588200 | 588620 | WMM |  |  | 587700 |  | TCS-4
589620 | 590050 | TCS-6C |  | 588620 | 588640 | SG |  |  | 587960 |  | TCS-4
590050 | 592000 | TCS-4 |  | 588640 | 588790 | GSB |  |  | 588620 | GSB | TCS-4
592000 | 592570 | TCS-6C |  | 588790 | 590100 |  |  |  | 588700 | SG | TCS-4
592570 | 593120 | TCS-6D |  | 590100 | 590590 | GSB |  |  | 588710 | SG | TCS-6C
593120 | 593400 | TCS-5D |  | 590590 | 590940 |  |  |  | 588820 |  | TCS-6C
593400 | 594320 | TCS-6C |  | 590940 | 591210 | WMM |  |  | 590050 |  | TCS-6C
594320 | 594600 | TCS-5D |  | 591210 | 591920 | DBM |  |  | 590100 |  | TCS-4
594600 | 595660 | TCS-1 |  | 591920 | 591930 | GSB |  |  | 590150 | GSB | TCS-4
595660 | 597110 | TCS-2B |  | 591930 | 594520 |  |  |  | 590590 |  | TCS-4
597110 | 597700 | TCS-2A |  | 594520 | 594530 | SG |  |  | 590710 |  | TCS-4
597700 | 599700 | TCS-4 |  | 594530 | 594540 | WMM |  |  | 590940 |  | TCS-4
599700 | 600250 | TCS-3 |  | 594540 | 595430 | DBM |  |  | 591210 | GSB | TCS-4
600250 | 601600 | TCS-2A |  | 595430 | 595440 | WMM |  |  | 591920 | DBM | TCS-4
601600 | 602000 | TCS-2B |  | 595440 | 595460 | SG |  |  | 591930 | GSB | TCS-4
602000 | 602125 | TCS-9 |  | 595460 | 595800 |  |  |  | 592000 |  | TCS-4
602125 | 603530 | TCS-6B |  | 595800 | 595850 | GSB |  |  | 592570 |  | TCS-6C
603530 | 612330 | TCS-9 |  | 595850 | 596830 | DBM |  |  | 593120 |  | TCS-6D
612330 | 612420 | TCS-8 |  | 596830 | 596910 | GSB |  |  | 593400 |  | TCS-5D
612420 | 613080 | TCS-9 |  | 596910 | 597240 |  |  |  | 594320 |  | TCS-6C
613080 | 613180 | TCS-8 |  | 597240 | 597250 | GSB |  |  | 594520 |  | TCS-5D
613180 | 613740 | TCS-9 |  | 597250 | 597260 | WMM |  |  | 594530 | SG | TCS-5D
613740 | 613890 | TCS-8 |  | 597260 | 597710 | DBM |  |  | 594540 | WMM | TCS-5D
613890 | 614040 | TCS-9 |  | 597710 | 597770 | GSB |  |  | 594600 | DBM | TCS-5D
614040 | 614240 | TCS-8 |  | 597770 | 597820 | SG |  |  | 595430 | DBM | TCS-1
614240 | 614630 | TCS-9 |  | 597820 | 597860 |  |  |  | 595440 | WMM | TCS-1
614630 | 614690 | TCS-8 |  | 597860 | 597880 | GSB |  |  | 595460 | SG | TCS-1
614690 | 615710 | TCS-9 |  | 597880 | 597970 | WMM |  |  | 595660 |  | TCS-1
615710 | 615880 | TCS-8 |  | 597970 | 597990 | GSB |  |  | 595800 |  | TCS-2B
615880 | 616080 | TCS-9 |  | 597990 | 598100 |  |  |  | 596910 | GSB | TCS-2B
616080 | 616150 | TCS-8 |  | 598100 | 598560 | DBM |  |  | 597110 |  | TCS-2B
616150 | 616260 | TCS-9 |  | 598560 | 598600 | GSB |  |  | 597240 |  | TCS-2A
616260 | 616400 | TCS-8 |  | 598600 | 598620 | SG |  |  | 597250 | GSB | TCS-2A
616400 | 618960 | TCS-9 |  | 598620 | 598630 |  |  |  | 597260 | WMM | TCS-2A
618960 | 619110 | TCS-8 |  | 598630 | 598640 | SG |  |  | 597700 | DBM | TCS-2A
619110 | 619640 | TCS-9 |  | 598640 | 599070 | DBM |  |  | 597710 | DBM | TCS-4
619640 | 620750 | COS TCS |  | 599070 | 599160 | GSB |  |  | 597770 | GSB | TCS-4
620750 | 621000 | TCS-2B |  | 599160 | 599250 |  |  |  | 597820 | SG | TCS-4
621000 | 621700 | TCS-4 |  | 599250 | 599260 | SG |  |  | 597860 |  | TCS-4
621700 | 622630 | TCS-6B |  | 599260 | 599270 | GSB |  |  | 597880 | GSB | TCS-4
622630 | 622725 | TCS-6A |  | 599270 | 599690 | DBM |  |  | 597970 | WMM | TCS-4
622725 | 622850 | TCS-5 |  | 599690 | 599700 | GSB |  |  | 597990 | GSB | TCS-4
622850 | 623135 | TCS-5A |  | 599700 | 601680 | DBM |  |  | 598100 |  | TCS-4
623135 | 624250 | TCS-6C |  | 601680 | 601700 | WMM |  |  | 598560 | DBM | TCS-4
624250 | 627850 | TCS-4 |  | 601700 | 603470 |  |  |  | 598600 | GSB | TCS-4
627850 | 628120 | TCS-6C |  | 603470 | 603540 | SG |  |  | 598620 | SG | TCS-4
628120 | 628440 | TCS-6C |  | 603540 | 603700 |  |  |  | 598630 |  | TCS-4
628440 | 629460 | TCS-4 |  | 603700 | 604330 | DBM |  |  | 598640 | SG | TCS-4
629460 | 629610 | TCS-7 |  | 604330 | 604340 | WMM |  |  | 599070 | DBM | TCS-4
629610 | 629880 | TCS-4 |  | 604340 | 604410 | GSB |  |  | 599160 | GSB | TCS-4
629880 | 630625 | TCS-6C |  | 604410 | 604420 |  |  |  | 599250 |  | TCS-4
630625 | 630960 | TCS-1 |  | 604420 | 604570 | WMM |  |  | 599260 | SG | TCS-4
 |  |  |  | 604570 | 604670 |  |  |  | 599270 | GSB | TCS-4
 |  |  |  | 604670 | 604800 | GSB |  |  | 599690 | DBM | TCS-4
 |  |  |  | 604800 | 609800 |  |  |  | 599700 | GSB | TCS-4
 |  |  |  | 609800 | 611260 | GSB |  |  | 600250 | DBM | TCS-3
 |  |  |  | 611260 | 612700 |  |  |  | 601080 | DBM | TCS-2A
 |  |  |  | 612700 | 612880 | GSB |  |  | 601360 | GSB | TCS-2A
 |  |  |  | 612880 | 612890 |  |  |  | 601380 | WMM | TCS-2A
 |  |  |  | 612890 | 613200 | DBM |  |  | 601600 | DBM | TCS-2A
 |  |  |  | 613200 | 613250 |  |  |  | 601680 | DBM | TCS-2B
 |  |  |  | 613250 | 613260 | WMM |  |  | 601700 | WMM | TCS-2B
 |  |  |  | 613260 | 613480 | DBM |  |  | 602000 |  | TCS-2B
 |  |  |  | 613480 | 613490 | WMM |  |  | 602125 |  | TCS-9
 |  |  |  | 613490 | 613500 |  |  |  | 603470 |  | TCS-6B
 |  |  |  | 613500 | 613640 | GSB |  |  | 603530 | SG | TCS-6B
 |  |  |  | 613640 | 613790 |  |  |  | 603540 | SG | TCS-9
 |  |  |  | 613790 | 614060 | GSB |  |  | 603700 |  | TCS-9
 |  |  |  | 614060 | 614220 | SG |  |  | 603900 | GSB | TCS-9
 |  |  |  | 614220 | 614320 | WMM |  |  | 604110 | WMM | TCS-9
 |  |  |  | 614320 | 614540 | GSB |  |  | 604200 |  | TCS-9
 |  |  |  | 614540 | 614750 |  |  |  | 604410 | GSB | TCS-9
 |  |  |  | 614750 | 615730 | GSB |  |  | 604420 |  | TCS-9
 |  |  |  | 615730 | 615760 |  |  |  | 604570 | WMM | TCS-9
 |  |  |  | 615760 | 615850 | SG |  |  | 604670 |  | TCS-9
 |  |  |  | 615850 | 616010 | GSB |  |  | 604800 | GSB | TCS-9
 |  |  |  | 616010 | 616090 | SG |  |  | 605100 |  | TCS-9
 |  |  |  | 616090 | 616140 |  |  |  | 605500 |  | TCS-9
 |  |  |  | 616140 | 616200 | GSB |  |  | 606490 |  | TCS-9
 |  |  |  | 616200 | 616410 | WMM |  |  | 609800 |  | TCS-9
 |  |  |  | 616410 | 616450 | SG |  |  | 611260 | GSB | TCS-9
 |  |  |  | 616450 | 616540 |  |  |  | 612330 |  | TCS-9
 |  |  |  | 616540 | 616600 | SG |  |  | 612420 |  | TCS-8
 |  |  |  | 616600 | 616820 | GSB |  |  | 612700 |  | TCS-9
 |  |  |  | 616820 | 616840 |  |  |  | 612880 | GSB | TCS-9
 |  |  |  | 616840 | 616860 | GSB |  |  | 613080 |  | TCS-9
 |  |  |  | 616860 | 616960 |  |  |  | 613180 |  | TCS-8
 |  |  |  | 616960 | 617060 | WMM |  |  | 613500 |  | TCS-9
 |  |  |  | 617060 | 617150 |  |  |  | 613640 | GSB | TCS-9
 |  |  |  | 617150 | 617230 | GSB |  |  | 613740 |  | TCS-9
 |  |  |  | 617230 | 617300 |  |  |  | 613790 |  | TCS-8
 |  |  |  | 617300 | 617840 | GSB |  |  | 613890 | GSB | TCS-8
 |  |  |  | 617840 | 618010 | WMM |  |  | 614040 | GSB | TCS-9
 |  |  |  | 618010 | 618220 | GSB |  |  | 614060 | GSB | TCS-8
 |  |  |  | 618220 | 618240 |  |  |  | 614220 | SG | TCS-8
 |  |  |  | 618240 | 618950 | GSB |  |  | 614240 | WMM | TCS-8
 |  |  |  | 618950 | 619050 |  |  |  | 614320 | WMM | TCS-9
 |  |  |  | 619050 | 619140 | GSB |  |  | 614540 | GSB | TCS-9
 |  |  |  | 619140 | 619650 | WMM |  |  | 614630 |  | TCS-9
 |  |  |  | 619650 | 620690 | DBM |  |  | 614690 |  | TCS-8
 |  |  |  | 620690 | 620960 | WMM |  |  | 614750 |  | TCS-9
 |  |  |  | 620960 | 624940 |  |  |  | 615710 | GSB | TCS-9
 |  |  |  | 624940 | 625350 | DBM |  |  | 615730 | GSB | TCS-8
 |  |  |  | 625350 | 625450 | WMM |  |  | 615760 |  | TCS-8
 |  |  |  | 625450 | 626060 | DBM |  |  | 615850 | SG | TCS-8
 |  |  |  | 626060 | 626070 | GSB |  |  | 615880 | GSB | TCS-8
 |  |  |  | 626070 | 626120 |  |  |  | 616010 | GSB | TCS-9
 |  |  |  | 626120 | 626140 | GSB |  |  | 616080 |  | TCS-9
 |  |  |  | 626140 | 626620 | DBM |  |  | 616090 | SG | TCS-8
 |  |  |  | 626620 | 626630 | WMM |  |  | 616140 |  | TCS-8
 |  |  |  | 626630 | 626820 |  |  |  | 616150 | GSB | TCS-8
 |  |  |  | 626820 | 626830 | WMM |  |  | 616200 | GSB | TCS-9
 |  |  |  | 626830 | 627300 | DBM |  |  | 616260 | WMM | TCS-9
 |  |  |  | 627300 | 627310 | WMM |  |  | 616400 | WMM | TCS-8
 |  |  |  | 627310 | 627340 | GSB |  |  | 616410 | WMM | TCS-9
 |  |  |  | 627340 | 627430 | DBM |  |  | 616450 | SG | TCS-9
 |  |  |  | 627430 | 627530 | WMM |  |  | 616540 |  | TCS-9
 |  |  |  | 627530 | 627550 | GSB |  |  | 616600 | SG | TCS-9
 |  |  |  | 627550 | 629120 |  |  |  | 616820 | GSB | TCS-9
 |  |  |  | 629120 | 629750 | DBM |  |  | 616840 |  | TCS-9
 |  |  |  | 629750 | 629770 | WMM |  |  | 616860 | GSB | TCS-9
 |  |  |  | 629770 | 629790 | GSB |  |  | 616960 |  | TCS-9
 |  |  |  | 629790 | 629810 | SG |  |  | 617060 | WMM | TCS-9
 |  |  |  | 629810 | 629910 |  |  |  | 617150 |  | TCS-9
 |  |  |  | 629910 | 630210 | SG |  |  | 617230 | GSB | TCS-9
 |  |  |  | 630210 | 630240 |  |  |  | 617300 |  | TCS-9
 |  |  |  | 630240 | 630340 | GSB |  |  | 617840 | GSB | TCS-9
 |  |  |  | 630340 | 630960 |  |  |  | 618010 | WMM | TCS-9
 |  |  |  |  |  |  |  |  | 618220 | GSB | TCS-9
 |  |  |  |  |  |  |  |  | 618240 |  | TCS-9
 |  |  |  |  |  |  |  |  | 618950 | GSB | TCS-9
 |  |  |  |  |  |  |  |  | 618960 |  | TCS-9
 |  |  |  |  |  |  |  |  | 619050 |  | TCS-8
 |  |  |  |  |  |  |  |  | 619110 | GSB | TCS-8
 |  |  |  |  |  |  |  |  | 619140 | GSB | TCS-9
 |  |  |  |  |  |  |  |  | 619640 | WMM | TCS-9
 |  |  |  |  |  |  |  |  | 619650 | WMM | COS TCS
 |  |  |  |  |  |  |  |  | 620690 | DBM | COS TCS
 |  |  |  |  |  |  |  |  | 620750 | WMM | COS TCS
 |  |  |  |  |  |  |  |  | 620960 | WMM | TCS-2B
 |  |  |  |  |  |  |  |  | 621000 |  | TCS-2B
 |  |  |  |  |  |  |  |  | 621700 |  | TCS-4
 |  |  |  |  |  |  |  | 621400 | 621700 |  | TCS-4
 |  |  |  |  |  |  |  |  | 622630 |  | TCS-6B
 |  |  |  |  |  |  |  |  | 622725 |  | TCS-6A
 |  |  |  |  |  |  |  |  | 622850 |  | TCS-5
 |  |  |  |  |  |  |  |  | 623135 |  | TCS-5A
 |  |  |  |  |  |  |  |  | 623300 |  | TCS-6C
 |  |  |  |  |  |  |  |  | 623500 |  | TCS-6C
 |  |  |  |  |  |  |  |  | 624060 |  | TCS-6C
 |  |  |  |  |  |  |  |  | 624250 |  | TCS-6C
 |  |  |  |  |  |  |  |  | 624940 |  | TCS-4
 |  |  |  |  |  |  |  |  | 625350 | DBM | TCS-4
 |  |  |  |  |  |  |  |  | 625450 | GSB | TCS-4
 |  |  |  |  |  |  |  |  | 626060 | DBM | TCS-4
 |  |  |  |  |  |  |  |  | 626070 | GSB | TCS-4
 |  |  |  |  |  |  |  |  | 626120 |  | TCS-4
 |  |  |  |  |  |  |  |  | 626140 | GSB | TCS-4
 |  |  |  |  |  |  |  |  | 626620 | DBM | TCS-4
 |  |  |  |  |  |  |  |  | 626630 | WMM | TCS-4
 |  |  |  |  |  |  |  |  | 626820 |  | TCS-4
 |  |  |  |  |  |  |  |  | 626830 | WMM | TCS-4
 |  |  |  |  |  |  |  |  | 627300 | DBM | TCS-4
 |  |  |  |  |  |  |  |  | 627310 | WMM | TCS-4
 |  |  |  |  |  |  |  |  | 627340 | GSB | TCS-4
 |  |  |  |  |  |  |  |  | 627430 | DBM | TCS-4
 |  |  |  |  |  |  |  |  | 627550 | GSB | TCS-4
 |  |  |  |  |  |  |  |  | 627750 |  | TCS-4
 |  |  |  |  |  |  |  |  | 627850 |  | TCS-4
 |  |  |  |  |  |  |  |  | 628440 |  | TCS-6C
 |  |  |  |  |  |  |  |  | 628600 |  | TCS-4
 |  |  |  |  |  |  |  |  | 629120 |  | TCS-4
 |  |  |  |  |  |  |  |  | 629460 | DBM | TCS-4
 |  |  |  |  |  |  |  |  | 629610 | DBM | TCS-7
 |  |  |  |  |  |  |  |  | 629750 | DBM | TCS-4
 |  |  |  |  |  |  |  |  | 629770 | WMM | TCS-4
 |  |  |  |  |  |  |  |  | 629790 | GSB | TCS-4
 |  |  |  |  |  |  |  |  | 629810 | SG | TCS-4
 |  |  |  |  |  |  |  |  | 629880 |  | TCS-4
 |  |  |  |  |  |  |  |  | 629910 |  | TCS-6C
 |  |  |  |  |  |  |  |  | 630210 | SG | TCS-6C
 |  |  |  |  |  |  |  |  | 630240 |  | TCS-6C
 |  |  |  |  |  |  |  |  | 630340 | GSB | TCS-6C
 |  |  |  |  |  |  |  |  | 630450 |  | TCS-6C
 |  |  |  |  |  |  |  |  | 630625 |  | TCS-6C
 |  |  |  |  |  |  |  |  | 630630 |  | TCS-1
 |  |  |  |  |  |  |  |  | 630960 |  | TCS-1