Spreadsheet: 770850d1646301409-merging-data-for-match-cases-only-matching-merge
Sheet: Demo

MYID | Rate
961709 | 122
961729 | 24
962300 | 24
962301 | 29
962302 | 26
962303 | 24
962304 | 302
962305 | 45
962306 | 194
962307 | 24
962308 | 1142
962309 | 24
962310 | 24
962311 | 40
962312 | 24
962313 | 24
962314 | 214
962315 | 24
962316 | 25
962317 | 24
962318 | 34
962319 | 26
962320 | 26
962321 | 25
962322 | 25
962323 | 40
962324 | 16
962325 | 190
962326 | 24
962327 | 29
962328 | 36
962329 | 193
962330 | 24
962331 | 24
962332 | 37
962333 | 26
962334 | 24
962335 | 24
962336 | 24
962337 | 211
962338 | 24
962339 | 26
962340 | 24
962341 | 24
962342 | 29
962343 | 29
962344 | 24
962345 | 141
962346 | 25
962347 | 26
962348 | 27
962349 | 26
962350 | 24
962351 | 24
962352 | 35
962353 | 31
962354 | 34
962355 | 38
962356 | 41
962357 | 26
962358 | 27
962359 | 24
962360 | 24
962361 | 25
962362 | 24
962363 | 24
962364 | 26
962365 | 35
962366 | 25
962367 | 25
962382 | 24
962383 | 24
962385 | 24
962386 | 24
962387 | 24
962388 | 25
962389 | 24
962390 | 24
962391 | 24
962392 | 26
962393 | 24
962394 | 26
962395 | 24
962396 | 24
962397 | 24
962398 | 6
962399 | 25
962400 | 28
962401 | 327
962402 | 35
962403 | 24
962404 | 25
962405 | 27
962406 | 2
962407 | 646
962408 | 646
962409 | 2
962410 | 640
962411 | 28
962412 | 174
962414 | 24
962415 | 25
962416 | 25
962417 | 0
962651 | 24
962652 | 24
962653 | 24
962654 | 25
962655 | 24
962656 | 0
962657 | 24
962658 | 25
962659 | 13
962660 | 47
962661 | 46
962662 | 0
962663 | 24
962664 | 12
962665 | 24
962666 | 12
962667 | 8
962668 | 40
962669 | 39
962677 | 35
962678 | 31
962679 | 24
962682 | 24
962683 | 28
962684 | 24
962685 | 27
962686 | 1
962687 | 37
962688 | 36
962689 | 37
962692 | 25
962693 | 28
962694 | 9
962695 | 25
962696 | 24
962697 | 25
962698 | 24
962699 | 24
962700 | 25
962701 | 25
962704 | 24
962705 | 24
962706 | 24
962707 | 24
962708 | 24
962709 | 24
962710 | 24
962713 | 1016
962714 | 529
962715 | 221
962716 | 221
962717 | 40
962718 | 24
962719 | 35
962720 | 43
962722 | 30
962723 | 37
962724 | 24
962726 | 25
962728 | 24
962729 | 24
962731 | 183
962732 | 181
962734 | 24
962735 | 24
962738 | 24
962740 | 24
962741 | 24
962742 | 24
962744 | 24
962745 | 24
962747 | 24
962749 | 24
962750 | 24
962752 | 27
962753 | 27
962754 | 26
962756 | 25
962758 | 169
962780 | 13729
962782 | 57
962786 | 24
962788 | 25
962789 | 24
962790 | 1515
962792 | 24
962793 | 26
962795 | 24
962796 | 0
962797 | 47
962799 | 48
962800 | 4
962801 | 29
962803 | 27
962804 | 28
962805 | 31
962806 | 28
962808 | 28
962809 | 29
962810 | 0
962811 | 107
962813 | 1
962814 | 662
962815 | 34
962816 | 33
962821 | 29
962822 | 26
962823 | 33
962824 | 25
962825 | 24
962826 | 25
962827 | 39
962828 | 25
962833 | 24
962834 | 24
962835 | 27
962836 | 25
962837 | 36
962838 | 29
962839 | 31
962840 | 38
962841 | 24
962842 | 26
962848 | 24
962849 | 24
962850 | 24
962851 | 24
962852 | 24
962853 | 24
962854 | 24
962856 | 24
962858 | 24
962859 | 35
962860 | 25
962861 | 24
962862 | 28
962869 | 24
962872 | 5
962877 | 43
962878 | 148
962879 | 24
962880 | 24
962883 | 31
962884 | 27
962885 | 31
962886 | 37
962887 | 40
962890 | 33
962891 | 24
962892 | 24
962893 | 24
962894 | 36
962895 | 0
962896 | 24
962897 | 24
962898 | 24
962899 | 24
962900 | 24
963005 | 1112
963006 | 28
963007 | 37
963008 | 24
963009 | 24
963010 | 25
963019 | 24
963020 | 24
963021 | 24
963022 | 27
963023 | 24
963024 | 24
963025 | 24
963026 | 24
963027 | 26
963028 | 24
963029 | 272
963030 | 0
963031 | 320
963050 | 24
963051 | 272
963052 | 49
963053 | 30
963054 | 35
963055 | 28
963056 | 33
963057 | 28
963058 | 28
963059 | 28
963060 | 28
963061 | 28
963062 | 199
963063 | 473
963064 | 25
963065 | 26
963066 | 40
963067 | 37
963068 | 32
963069 | 25
963070 | 25
963071 | 29
963072 | 25
963073 | 24
963074 | 24
963075 | 36
963076 | 25
963077 | 27
963078 | 0
963079 | 24
963080 | 24
963081 | 24
963082 | 24
963083 | 24
963084 | 24
963085 | 26
963086 | 24
963087 | 25
963088 | 24
963089 | 27
963090 | 26
963091 | 65
963092 | 37
963093 | 24
963094 | 37
963095 | 1053042
963096 | 39
963097 | 36
963098 | 46
963099 | 24
963100 | 24
963101 | 64
963102 | 106
963103 | 403
963104 | 54
963105 | 58
963106 | 24
963107 | 103
963108 | 58
963109 | 24
963110 | 24
963111 | 24
963112 | 25
963113 | 24
963114 | 24
963115 | 24
963116 | 24
963117 | 24
963118 | 24
963119 | 24
963120 | 214
963121 | 216
963122 | 24
963123 | 24
963124 | 25
963125 | 24
963126 | 236
963140 | 24
963141 | 25
963142 | 25
963143 | 239
963144 | 24
963203 | 24
963204 | 302
963608 | 24
963609 | 25
963610 | 224
963611 | 260
963612 | 24
963613 | 24
963615 | 24
963616 | 24
963617 | 24
963618 | 24
963619 | 24
963620 | 24
963621 | 24
963624 | 676
963625 | 24
963626 | 24
963627 | 58
963628 | 24
963629 | 0
963630 | 24
963631 | 25
963632 | 29
963633 | 24
963634 | 25
963635 | 327
963636 | 28
963637 | 25
963638 | 26
963639 | 24
963640 | 26
963641 | 34
963642 | 43
963649 | 24
963650 | 31
963651 | 448
963652 | 27
963653 | 25
963654 | 24
963655 | 26
963656 | 266
963657 | 250
963798 | 67
963801 | 24
963803 | 79
963804 | 28
963806 | 29
963807 | 28
963809 | 287
963810 | 50
963811 | 49
963813 | 29
963814 | 27
963815 | 574
963819 | 351
963820 | 2
963821 | 24
963822 | 40
963824 | 26
963825 | 26
963826 | 46
963827 | 31
963829 | 35
963830 | 61
963834 | 24
963836 | 24
963838 | 1
963839 | 63
963840 | 32
963842 | 24
963844 | 36
963846 | 24
963847 | 43
963849 | 25
963850 | 25
963852 | 24
963853 | 24
963855 | 25
963856 | 41
963858 | 24
963859 | 24
963860 | 0
963861 | 49
963862 | 24
963864 | 25
963865 | 24
963866 | 24
963868 | 680
963869 | 38
963871 | 25
963872 | 29
963873 | 24
963920 | 24
963926 | 24
963933 | 26
963940 | 0
963941 | 28
963942 | 24
963943 | 0
963944 | 24
963945 | 35
963946 | 34
963947 | 24
963948 | 241
964363 | 36
964364 | 38
964365 | 26
964366 | 37
964367 | 36
964368 | 24
964369 | 24
964370 | 24
964371 | 24
964372 | 24
964374 | 24
964375 | 24
964376 | 231
964377 | 24
964379 | 24
964380 | 24
964412 | 63
964415 | 60
964416 | 24
964417 | 24
964420 | 0
964423 | 47
964424 | 26
964425 | 58
964426 | 56
964427 | 24
964428 | 283
964429 | 25
964430 | 25
964431 | 1000
964432 | 25
964433 | 1
964434 | 42
964435 | 24
964436 | 24
964437 | 25
964438 | 39
964439 | 24
964440 | 24
964441 | 26
964442 | 24
964443 | 26
964444 | 829
964445 | 62
964446 | 787
964447 | 24
964448 | 24
964449 | 24
964450 | 24
964451 | 264
964452 | 24
964453 | 14
964454 | 41
964455 | 24
964456 | 32
964457 | 29
964458 | 24
964459 | 27
964460 | 43
964461 | 28
964462 | 23
964463 | 25
964464 | 24
964465 | 24
964466 | 24
964467 | 24
964468 | 24
964469 | 61
964470 | 0
964471 | 24
964472 | 41
964473 | 26
964474 | 4
964475 | 25
964476 | 32
964477 | 41
964478 | 594
964846 | 1289
964847 | 25
964848 | 189
964849 | 25
964850 | 3
964851 | 711
964852 | 24
964854 | 184
964856 | 244
964858 | 24
964859 | 24
964860 | 24
964861 | 24
964862 | 24
964863 | 24
964864 | 24
964865 | 24
964867 | 24
964868 | 19
964870 | 24
964871 | 178
964872 | 24
964873 | 24
964875 | 48
964876 | 33
964877 | 26
964879 | 54
964881 | 421
964882 | 60
964883 | 14
964884 | 27
964885 | 37
964886 | 63
964887 | 63
964888 | 0
964889 | 1
964890 | 26
964891 | 31
964892 | 48
964893 | 28
964894 | 32
964895 | 3
964896 | 30
964897 | 25
964898 | 27
964899 | 24
964900 | 24
964901 | 24
964902 | 24
964903 | 1486
964904 | 25
964905 | 25
964906 | 26
964907 | 26
964908 | 39
964909 | 36
964910 | 35
964911 | 40
964912 | 49
964913 | 64
964914 | 41
964915 | 46
964916 | 67
964917 | 67
964918 | 28
964919 | 32
964920 | 28
964921 | 24
964922 | 27
964923 | 190
964924 | 4
964925 | 31
964926 | 39
964927 | 24
964928 | 33
964959 | 24
964960 | 24
964961 | 1
964962 | 534
964963 | 34
965881 | 24
965898 | 26
965901 | 24
965907 | 35
965908 | 35
965909 | 27
965910 | 28
965911 | 29
965912 | 24
965913 | 24
965914 | 26
965915 | 25
965916 | 24
965917 | 25
965918 | 60
965921 | 56
965924 | 32
965930 | 24
965931 | 26
965932 | 220
965933 | 24
965934 | 24
965935 | 1
965936 | 24
965937 | 24
965938 | 27
965939 | 141
965940 | 26
965941 | 24
965942 | 326
965943 | 24
965944 | 24
965945 | 24
965946 | 25
965947 | 27
965948 | 32
965949 | 31
965950 | 27
965951 | 25
965952 | 164
965978 | 26
965979 | 24
965980 | 32
965981 | 24
965982 | 27
965983 | 25
965984 | 25
965985 | 24
965986 | 25
965987 | 24
965988 | 24
965997 | 26
966068 | 43
966069 | 34
966097 | 24
966098 | 24
966099 | 36
966100 | 44
966104 | 25
966108 | 362
966109 | 243
966110 | 31
966111 | 90
966158 | 159
966159 | 137
966160 | 20
966161 | 251
966760 | 231
966761 | 32
966762 | 32
966763 | 24
966764 | 25
966765 | 24
966766 | 27
966767 | 25
966768 | 24
966769 | 0
966770 | 24
966771 | 621
966772 | 949
966773 | 24
966775 | 0
966776 | 24
966777 | 38
966778 | 45
966779 | 25
966780 | 170
966781 | 26
966782 | 27
966783 | 29
966784 | 275
966785 | 35
966786 | 35
966787 | 35
966788 | 1
966789 | 30
966790 | 43
966791 | 24
966792 | 35
966793 | 44
966794 | 24
966795 | 25
966796 | 24
966797 | 24
966798 | 25
966799 | 24
966800 | 24
966801 | 0
966802 | 5
966803 | 54
966804 | 26
966805 | 346
966806 | 24
966807 | 24
966808 | 24
966809 | 24
966810 | 257
966811 | 24
966812 | 24
966813 | 783
966814 | 36
966815 | 34
966816 | 25
966817 | 24
966818 | 31
966819 | 24
966820 | 307
966821 | 593
966822 | 24
966823 | 164
966824 | 164
966825 | 25
966826 | 27
966827 | 27
966828 | 24
966829 | 24
966830 | 30
966831 | 24
966832 | 26
966833 | 24
966834 | 24
966835 | 24
966836 | 25
966837 | 26
966838 | 542
966839 | 25
966840 | 35
966841 | 27
966842 | 35
966843 | 327
966844 | 24
966845 | 26
966846 | 24
966847 | 24
966848 | 26
966849 | 26
966850 | 26
966851 | 24
966852 | 29
966853 | 26
966854 | 24
966855 | 24
966856 | 307
966857 | 27
966858 | 45
966859 | 30
966860 | 24
966861 | 27
966862 | 25
966863 | 25
966864 | 27
966865 | 26
966899 | 28
966900 | 24
966901 | 35
966902 | 39
966903 | 38
966904 | 43
966908 | 43
966909 | 39
966990 | 29
966991 | 25
966992 | 125
966993 | 138
966994 | 43
966995 | 43
966996 | 36
966997 | 25
966998 | 27
966999 | 29
967000 | 112
967001 | 28
967002 | 28
967003 | 48
967004 | 5
967005 | 28
967006 | 28
967007 | 30
967008 | 28
967009 | 28
967010 | 0
967011 | 24
967012 | 65
967013 | 66
967014 | 33
967015 | 25
967016 | 30
967017 | 42
967018 | 271
967019 | 36
967020 | 41
967021 | 1715
967022 | 24
967023 | 25
967024 | 24
967025 | 25
967026 | 24
967027 | 24
967028 | 24
967029 | 24
967030 | 0
967031 | 26
967032 | 24
967033 | 25
967034 | 26
967035 | 24
967036 | 24
967037 | 24
967038 | 24
967039 | 25
967040 | 24
967041 | 167
967042 | 27
967043 | 24
967044 | 0
967045 | 26
967046 | 0
967047 | 24
967048 | 26
967049 | 26
967050 | 349
967051 | 24
967474 | 24
967475 | 25
967476 | 117
967477 | 32
967478 | 26
967479 | 53
967480 | 24
967481 | 79
967482 | 24
967483 | 24
967484 | 0
967485 | 4
967486 | 726
967487 | 24
967488 | 27
967489 | 31
967490 | 43
967491 | 305
967492 | 24
967493 | 24
967494 | 32
967495 | 24
967496 | 34
967497 | 427
967498 | 14
967499 | 67
967500 | 42
967501 | 24
967502 | 25
967503 | 160
967504 | 138
967505 | 24
967506 | 25
967507 | 24
967508 | 362
967509 | 26
967510 | 28
967511 | 26
967512 | 24
967513 | 26
967514 | 30
967515 | 24
967516 | 25
967517 | 26
967518 | 25
967519 | 25
967520 | 24
967521 | 24
967522 | 38
967523 | 42
967524 | 25
967525 | 37
967526 | 24
967527 | 25
967528 | 184
967529 | 24
967530 | 25
967531 | 24
967533 | 25
967534 | 26
967541 | 1
967542 | 29
967543 | 28
967544 | 28
967545 | 145
967546 | 174
967547 | 328
967548 | 25
967549 | 354
967550 | 57
967551 | 0
967552 | 24
967553 | 24
967554 | 24
967555 | 25
967556 | 0
967557 | 24
967558 | 24
967559 | 25
967560 | 25
967563 | 24
967564 | 312
967565 | 362
967566 | 24
967567 | 26
967568 | 48
967569 | 28
967570 | 24
967571 | 24
967770 | 27
967771 | 33
967799 | 30
967813 | 24
967814 | 24
967815 | 24
967816 | 24
967817 | 25
967818 | 24
967820 | 24
967821 | 46
967822 | 56
967823 | 24
967824 | 24
967825 | 0
967826 | 24
967827 | 24
967828 | 24
967830 | 25
967831 | 24
967832 | 24
967833 | 24
967834 | 714
967835 | 39
967837 | 45
967838 | 48
967839 | 1
967840 | 181
967841 | 32
967842 | 29
967843 | 30
967847 | 24
967848 | 28
967849 | 0
967850 | 28
967851 | 30
967852 | 29
967853 | 27
967854 | 28
967855 | 24
967856 | 29
967857 | 27
967858 | 359
967859 | 24
967860 | 24
967861 | 25
967862 | 24
967863 | 26
967864 | 24
967865 | 30
967866 | 28
967867 | 24
967868 | 26
967869 | 28
967870 | 26
967871 | 24
967872 | 33
967873 | 24
967874 | 177
967875 | 45
967876 | 37
967877 | 24
967878 | 27
967879 | 27
967880 | 24
967881 | 26
967882 | 24
967883 | 37
967884 | 28
967885 | 25
967886 | 28
967887 | 26
967888 | 24
967889 | 24
967890 | 24
967891 | 24
967892 | 24
967893 | 24
967894 | 25
967895 | 24
967896 | 27
967897 | 24
967898 | 24
967899 | 25
967900 | 24
967901 | 258
967902 | 29
967903 | 34
967904 | 24
967905 | 47
967906 | 41
967907 | 43
967908 | 26
967909 | 42
967910 | 38
967911 | 26
967912 | 26
967913 | 26
967914 | 26
967915 | 25
967916 | 24
967917 | 25
967918 | 25
967919 | 165
967920 | 434
967921 | 24
967922 | 25
967923 | 25
967924 | 24
967925 | 34
967926 | 49
967927 | 41
967928 | 2
967929 | 148
967930 | 24
967931 | 124
967932 | 0
967933 | 24
967934 | 24
967935 | 48
967936 | 34
967937 | 52
967938 | 37
967939 | 24
967940 | 0
967941 | 27
967942 | 24
967943 | 36
967944 | 28
967945 | 33
967946 | 24
967947 | 25
967948 | 27
967949 | 48
967950 | 63
967951 | 24
967952 | 25
967953 | 25
967954 | 24
967955 | 28
967956 | 32
967957 | 26
967958 | 145
967959 | 187
967960 | 29
967961 | 26
967962 | 36
967963 | 26
967964 | 26
967965 | 24
967966 | 24
967967 | 24
967968 | 24
967969 | 24
967970 | 25
967971 | 24
967972 | 24
967973 | 24
967974 | 24
967975 | 24
967985 | 41
967986 | 56
967987 | 24
967988 | 30
967989 | 24
967990 | 170
967991 | 27
967992 | 24
967993 | 25
967994 | 26
967995 | 24
967996 | 36
967997 | 25
967998 | 24
967999 | 28
968000 | 410
968004 | 30
968005 | 26
968006 | 24
968080 | 41
968081 | 44
968082 | 24
968083 | 24
968084 | 25
968085 | 24
968097 | 39
968098 | 1
968099 | 461
968100 | 24
968101 | 24
968102 | 24
968103 | 24
968104 | 25
968105 | 24
968106 | 56
968107 | 25
968108 | 24
968109 | 24
968110 | 26
968111 | 24
968112 | 24
968113 | 24
968114 | 59
968115 | 24
968116 | 24
968117 | 24
968118 | 29
968119 | 62
968120 | 24
968121 | 24
968122 | 386
968123 | 43
968124 | 34
968125 | 39
968126 | 60
968127 | 27
968128 | 44
968129 | 65
968130 | 29
968131 | 306
968132 | 38
968133 | 24
968134 | 44
968135 | 24
968136 | 31
968137 | 31
968138 | 24
968139 | 258
968140 | 24
968141 | 24
968142 | 24
968143 | 781
968144 | 38