Spreadsheet: 871708d1718124185-combining-two-seperate-with-common-id-sample-file-jaffirahamed1-
Sheet: Output

ID | Business | %age | Value | Total | Country Name | %age | Value | Total
B-AM-CMDB-2021BRAM-1plus | Apple | 1 | 1 | 1 | Not Available | 0.0445505171042164 | 56 | 12
B-AM-CMDB-2021BRAM-1plus | [NAME] | 0 | 0 | 6 | Not Available | 0.0146541617819461 | 25 | 20
B-AM-CMDB-2021BRAM-1plus | Orange | 0 | 0 | 26 | Angola | 0 | 0 | 27
B-AM-CMDB-2021BRAM-1plus | Abcd | 0.103896103896104 | 8 | 77 | Bahrain | 0 | 0 | 78
B-AM-CMDB-2021BRAM-1plus | Efgh | 0 | 0 | 33 | Botswana | 0 | 0 | 69
B-AM-CMDB-2021BRAM-1plus |  |  |  |  | Cameroon | 0 | 0 | 84
B-AM-CMDB-2021BRAM-1plus |  |  |  |  | [NAME] | 0 | 0 | 102
B-AM-CMDB-2021BRAM-1plus |  |  |  |  | Egypt | 0 | 0 | 44
B-AM-CMDB-2021BRAM-1plus |  |  |  |  | Gambia | 0.00847457627118644 | 1 | 118
B-AM-CMDB-2021BRAM-1plus |  |  |  |  | Ghana | 0.00436046511627907 | 3 | 688
B-AM-CMDB-2021BRAM-1plus |  |  |  |  | Iraq | 0 | 0 | 16
B-AM-CMDB-2021BRAM-1plus |  |  |  |  | Kenya | 0 | 0 | 223
B-AM-CMDB-2021BRAM-1plus |  |  |  |  | [NAME] | 0 | 0 | 75
B-AM-CMDB-2021BRAM-1plus |  |  |  |  | Nigeria | 0.00153139356814701 | 1 | 578
B-AM-CMDB-2021BRAM-1plus |  |  |  |  | Oman | 0 | 0 | 46
B-AM-CMDB-2021BRAM-1plus |  |  |  |  | Pakistan | 0.0028169014084507 | 6 | 568
B-AM-CMDB-2021BRAM-1plus |  |  |  |  | Qatar | 0 | 0 | 58
B-AM-IS-01 | Pine | 0 | 0 | 1 | Saudi Arabia | 0 | 0 | 52
B-AM-IS-01 | Applam | 0 | 0 | 12 | Sierra Leone | 0.0266666666666667 | 2 | 75
B-AM-IS-01 | [NAME] | 0 | 0 | 35 | South Africa | 0 | 0 | 294
B-AM-IS-01 | Idly | 0.0701754385964912 | 8 | 114 | TANZANIA, UNITED REPUBLIC OF | 0 | 0 | 215
B-AM-IS-01 | Vadai | 0.0238095238095238 | 1 | 42 | Uganda | 0 | 0 | 287
B-AM-IS-01 | Iddi | 0 | 0 | 12 | United Arab Emirates | 0.00273972602739726 | 2 | 730
B-AM-IS-01 |  |  |  |  | Zambia | 0.00334448160535117 | 1 | 299
B-AM-IS-01 |  |  |  |  | Zimbabwe | 0 | 0 | 227
B-AM-IS-01 |  |  |  |  | Australia | 0 | 0 | 97
B-AM-IS-01 |  |  |  |  | Bangladesh | 0.00043994720633524 | 1 | 47
B-AM-IS-01 |  |  |  |  | [NAME] | 0 | 0 | 36
B-AM-IS-01 |  |  |  |  | Cambodia | 0 | 0 | 1
B-AM-IS-01 |  |  |  |  | China | 0.000694348007221219 | 5 | 98
B-AM-IS-01 |  |  |  |  | Hong Kong | 0.0091743119266055 | 56 | 241
B-AM-IS-01 |  |  |  |  | India | 0.00281615770483147 | 96 | 789
B-AM-IS-01 |  |  |  |  | Indonesia | 0.0014609203798393 | 2 | 45
B-AM-IS-01 |  |  |  |  | Japan | 0 | 0 | 131
B-AM-IS-01 |  |  |  |  | Lao Peoples Democratic Rep | 0 | 0 | 1
B-AM-IS-01 |  |  |  |  | Macao | 0 | 0 | 5
B-AM-IS-01 |  |  |  |  | Malaysia | 0.00138850319355734 | 10 | 7202
B-AM-IS-01 |  |  |  |  | Myanmar | 0 | 0 | 1
B-AM-IS-01 |  |  |  |  | Nepal | 0 | 0 | 483
B-AM-IS-01 |  |  |  |  | Philippines | 0 | 0 | 298
B-AM-IS-01 |  |  |  |  | Singapore | 0.00286505586858944 | 30 | 10471
B-AM-IS-01 |  |  |  |  | [NAME] | 0.00174520069808028 | 1 | 573
B-AM-IS-01 |  |  |  |  | Taiwan | 0 | 0 | 2526
B-AM-IS-01 |  |  |  |  | Thailand | 0 | 0 | 461
B-AM-IS-01 |  |  |  |  | Vietnam | 0 | 0 | 69
B-AM-IS-01 |  |  |  |  | Argentina | 0 | 0 | 10
B-AM-IS-01 |  |  |  |  | Brazil | 0 | 0 | 35
B-AM-IS-01 |  |  |  |  | Colombia | 0 | 0 | 13
B-AM-IS-01 |  |  |  |  | Falkland Islands Flk | 0 | 0 | 20
B-AM-IS-01 |  |  |  |  | France | 0 | 0 | 89
B-AM-IS-01 |  |  |  |  | Germany | 0.0152091254752852 | 4 | 263
B-AM-IS-01 |  |  |  |  | Ireland | 0 | 0 | 4
B-AM-IS-01 |  |  |  |  | Jersey | 0.0106382978723404 | 1 | 94
B-AM-IS-01 |  |  |  |  | Poland | 0.0016220600162206 | 2 | 524
B-AM-IS-01 |  |  |  |  | Sweden | 0 | 0 | 13
B-AM-IS-01 |  |  |  |  | Turkiye | 0 | 0 | 27
B-AM-IS-01 |  |  |  |  | United Kingdom | 0.0123753867308353 | 36 | 658
B-AM-IS-01 |  |  |  |  | United States of America | 0.00088495575221239 | 1 | 77
B-AM-IS-01 |  |  |  |  | DUBAI INT FIN CENTRE (DIFC) | 0.00112485939257593 | 1 | 889
B-AM-IS-01 |  |  |  |  | Angola | '-- | 0 | 0
B-AM-IS-01 |  |  |  |  | Bahrain | 0 | 0 | 2
B-AM-IS-01 |  |  |  |  | Botswana | 0.5 | 1 | 2
B-AM-IS-01 |  |  |  |  | Cameroon | '-- | 0 | 0
B-AM-IS-01 |  |  |  |  | [NAME] | '-- | 0 | 0
B-AM-IS-01 |  |  |  |  | Gambia | '-- | 0 | 0
B-AM-IS-01 |  |  |  |  | Ghana | '-- | 0 | 0
B-AM-IS-01 |  |  |  |  | Iraq | '-- | 0 | 0
B-AM-IS-01 |  |  |  |  | Kenya | '-- | 0 | 0
B-AM-IS-01 |  |  |  |  | [NAME] | '-- | 0 | 0
B-AM-IS-01 |  |  |  |  | Nigeria | '-- | 0 | 0
B-AM-IS-01 |  |  |  |  | Oman | '-- | 0 | 0
B-AM-IS-01 |  |  |  |  | Pakistan | 0 | 0 | 1
B-AM-IS-01 |  |  |  |  | Qatar | '-- | 0 | 0
B-AM-IS-01 |  |  |  |  | Saudi Arabia | '-- | 0 | 0
B-AM-IS-01 |  |  |  |  | South Africa | 1 | 1 | 1
B-AM-IS-01 |  |  |  |  | TANZANIA, UNITED REPUBLIC OF | '-- | 0 | 0
B-AM-IS-01 |  |  |  |  | Uganda | 0 | 0 | 2
B-AM-IS-01 |  |  |  |  | United Arab Emirates | 0 | 0 | 2
B-AM-IS-01 |  |  |  |  | Zambia | '-- | 0 | 0
B-AM-IS-01 |  |  |  |  | Zimbabwe | '-- | 0 | 0
B-AM-IS-01 |  |  |  |  | Australia | '-- | 0 | 0
B-AM-IS-01 |  |  |  |  | Bangladesh | 0.25 | 1 | 4
B-AM-IS-01 |  |  |  |  | [NAME] | 0 | 0 | 1
B-AM-IS-01 |  |  |  |  | China | 0.111111111111111 | 2 | 18
B-AM-IS-01 |  |  |  |  | Hong Kong | 0 | 0 | 12
B-AM-IS-01 |  |  |  |  | India | 0.125 | 3 | 24
B-AM-IS-01 |  |  |  |  | Indonesia | 0.333333333333333 | 2 | 6
B-AM-IS-01 |  |  |  |  | Japan | '-- | 0 | 0
B-AM-IS-01 |  |  |  |  | KOREA, REPUBLIC OF | 0 | 0 | 31
B-AM-IS-01 |  |  |  |  | Malaysia | 0 | 0 | 8
B-AM-IS-01 |  |  |  |  | Nepal | '-- | 0 | 0
B-AM-IS-01 |  |  |  |  | Philippines | '-- | 0 | 0
B-AM-IS-01 |  |  |  |  | Singapore | 0.111111111111111 | 1 | 9
B-AM-IS-01 |  |  |  |  | [NAME] | '-- | 0 | 0
B-AM-IS-01 |  |  |  |  | Taiwan | 0.222222222222222 | 2 | 9
B-AM-IS-01 |  |  |  |  | Thailand | '-- | 0 | 0
B-AT-TRN-01 | Tiger | 0.003584229390681 | 1 | 12 | Vietnam | 0 | 0 | 5
B-AT-TRN-01 | Lion | 0.00361532899493854 | 10 | 14 | Germany | '-- | 0 | 0
B-AT-TRN-01 | Cheetah | 0 | 0 | 15 | Jersey | 1 | 1 | 1
B-AT-TRN-01 | Elepha | 0.000803305026394308 | 7 | 19 | United Kingdom | 0 | 0 | 1
B-AT-TRN-01 | Camel | 0.00404040404040404 | 2 | 10 | United States of America | 0 | 0 | 2
B-AT-TRN-01 | Rat | 0 | 0 | 14 | Invalid | 0.0281090289608177 | 33 | 5
B-AT-TRN-01 |  |  |  |  | Botswana | 0 | 0 | 11
B-AT-TRN-01 |  |  |  |  | Ghana | 0.0588235294117647 | 1 | 17
B-AT-TRN-01 |  |  |  |  | Kenya | 0.0431654676258993 | 6 | 139
B-AT-TRN-01 |  |  |  |  | Nigeria | 0.0217391304347826 | 1 | 46
B-AT-TRN-01 |  |  |  |  | Pakistan | 0.0614035087719298 | 7 | 114
B-AT-TRN-01 |  |  |  |  | South Africa | 0 | 0 | 20
B-AT-TRN-01 |  |  |  |  | TANZANIA, UNITED REPUBLIC OF | 0 | 0 | 3
B-AT-TRN-01 |  |  |  |  | Uganda | 0.0303030303030303 | 1 | 33
B-AT-TRN-01 |  |  |  |  | United Arab Emirates | 0.0263157894736842 | 2 | 76
B-AT-TRN-01 |  |  |  |  | Australia | 0 | 0 | 16
B-AT-TRN-01 |  |  |  |  | Bangladesh | 0 | 0 | 310
B-AT-TRN-01 |  |  |  |  | [NAME] | 0 | 0 | 15
B-AT-TRN-01 |  |  |  |  | China | 0.132420091324201 | 58 | 438
B-AT-TRN-01 |  |  |  |  | Hong Kong | 0.0303326810176125 | 31 | 1022
B-AT-TRN-01 |  |  |  |  | India | 0.0490196078431373 | 200 | 4080
B-AT-TRN-01 |  |  |  |  | Indonesia | 0.0256410256410256 | 7 | 273
B-AT-TRN-01 |  |  |  |  | Japan | 0 | 0 | 26
B-AT-TRN-01 |  |  |  |  | KOREA, REPUBLIC OF | 0 | 0 | 14
B-AT-TRN-01 |  |  |  |  | Malaysia | 0.0424528301886792 | 27 | 636
B-AT-TRN-01 |  |  |  |  | Nepal | 0.0909090909090909 | 2 | 22
B-AT-TRN-01 |  |  |  |  | Philippines | 0 | 0 | 27
B-AT-TRN-01 |  |  |  |  | Singapore | 0.0294540229885057 | 41 | 75
B-AT-TRN-01 |  |  |  |  | [NAME] | 0.0204081632653061 | 2 | 98
B-AT-TRN-01 |  |  |  |  | Taiwan | 0.00595238095238095 | 1 | 3654
B-AT-TRN-01 |  |  |  |  | Thailand | 0.012987012987013 | 1 | 77
B-AT-TRN-01 |  |  |  |  | Vietnam | 0.0285714285714286 | 4 | 140
B-AT-TRN-01 |  |  |  |  | Falkland Islands Flk | 0.125 | 2 | 16
B-AT-TRN-01 |  |  |  |  | Germany | 0.025 | 2 | 80
B-AT-TRN-01 |  |  |  |  | Ireland | 0 | 0 | 14
B-AT-TRN-01 |  |  |  |  | Poland | 0 | 0 | 56
B-AT-TRN-01 |  |  |  |  | United Kingdom | 0.0261194029850746 | 7 | 268
B-AT-TRN-01 |  |  |  |  | United States of America | 0.0384615384615385 | 3 | 78
B-AT-TRN-01 |  |  |  |  | DUBAI INT FIN CENTRE (DIFC) | 0.0333333333333333 | 1 | 30
B-AT-TRN-01 |  |  |  |  | Bahrain | 0 | 0 | 3
B-AT-TRN-01 |  |  |  |  | Ghana | 0 | 0 | 2
B-AT-TRN-01 |  |  |  |  | Iraq | 0 | 0 | 1
B-AT-TRN-01 |  |  |  |  | [NAME] | 0 | 0 | 2
B-AT-TRN-01 |  |  |  |  | Nigeria | 0 | 0 | 5
B-AT-TRN-01 |  |  |  |  | Oman | 0 | 0 | 1
B-AT-TRN-01 |  |  |  |  | Pakistan | 0 | 0 | 12
B-AT-TRN-01 |  |  |  |  | Qatar | 0 | 0 | 4
B-AT-TRN-01 |  |  |  |  | Uganda | 0 | 0 | 4
B-AT-TRN-01 |  |  |  |  | United Arab Emirates | 0 | 0 | 6
B-AT-TRN-01 |  |  |  |  | Zambia | 0 | 0 | 1
B-AT-TRN-01 |  |  |  |  | Bangladesh | 0 | 0 | 11
B-AT-TRN-01 |  |  |  |  | [NAME] | 0 | 0 | 2
B-AT-TRN-01 |  |  |  |  | China | 0 | 0 | 22
B-AT-TRN-01 |  |  |  |  | Hong Kong | 0 | 0 | 21
B-AT-TRN-01 |  |  |  |  | India | 0 | 0 | 76
B-AT-TRN-01 |  |  |  |  | Indonesia | 0.2 | 5 | 25
B-AT-TRN-01 |  |  |  |  | KOREA, REPUBLIC OF | 0.857142857142857 | 6 | 7
B-AT-TRN-01 |  |  |  |  | Malaysia | 0 | 0 | 12
B-AT-TRN-01 |  |  |  |  | Nepal | 0 | 0 | 7
B-AT-TRN-01 |  |  |  |  | Philippines | 0 | 0 | 4
B-AT-TRN-01 |  |  |  |  | Singapore | 0 | 0 | 8
B-AT-TRN-01 |  |  |  |  | [NAME] | 0 | 0 | 2
B-AT-TRN-01 |  |  |  |  | Taiwan | 0 | 0 | 41
B-AT-TRN-01 |  |  |  |  | Thailand | 0 | 0 | 3
B-AT-TRN-01 |  |  |  |  | Vietnam | 0 | 0 | 8
B-AT-TRN-01 |  |  |  |  | Jersey | 0 | 0 | 1
B-AT-TRN-01 |  |  |  |  | United Kingdom | 0 | 0 | 1
B-AT-TRN-01 |  |  |  |  | United States of America | 0 | 0 | 2
B-AT-TRN-01 |  |  |  |  | Invalid | 0.0279206465833946 | 38 | 1361
B-AT-TRN-01 |  |  |  |  | Not Available | 0.601503759398496 | 80 | 133
B-AT-TRN-01 |  |  |  |  | Not Available | 0.221374045801527 | 29 | 131
B-AT-TRN-01 |  |  |  |  | Not Available | 0.337539432176656 | 107 | 317
B-AT-TRN-01 |  |  |  |  | Not Available | 0.446969696969697 | 413 | 924
B-AT-TRN-01 |  |  |  |  | Not Available | 0 | 0 | 13
B-AT-TRN-01 |  |  |  |  | Not Available | 0.153846153846154 | 2 | 13
B-AT-TRN-01 |  |  |  |  | Not Available | 0.0899908172635445 | 98 | 1089
B-AT-TRN-01 |  |  |  |  | Not Available | 0.0375699440447642 | 47 | 1251
B-AT-TRN-01 |  |  |  |  | Not Available | 0.0898203592814371 | 15 | 167
B-AT-TRN-01 |  |  |  |  | Not Available | 0.0267062314540059 | 9 | 337
B-AT-TRN-01 |  |  |  |  | Not Available | 0.0511494252873563 | 178 | 3480
B-AT-TRN-01 |  |  |  |  | Not Available | 0.434782608695652 | 20 | 46
B-AT-TRN-01 |  |  |  |  | Not Available | 0.173913043478261 | 8 | 46
B-AT-TRN-01 |  |  |  |  | Not Available | 0.608695652173913 | 28 | 46
B-AT-TRN-01 |  |  |  |  | Not Available | 0.0666666666666667 | 3 | 45
B-AT-TRN-01 |  |  |  |  | Not Available | 0.673913043478261 | 31 | 46
B-AT-TRN-01 |  |  |  |  | Not Available | 0.032258064516129 | 1 | 31
B-AT-TRN-01 |  |  |  |  | Not Available | 0.0952380952380952 | 2 | 21
B-AT-TRN-01 |  |  |  |  | Not Available | 0.133333333333333 | 4 | 30
B-AT-TRN-01 |  |  |  |  | Not Available | 0.674418604651163 | 29 | 43
B-AT-TRN-01 |  |  |  |  | Not Available | 0.0869565217391304 | 4 | 46
B-AT-TRN-01 |  |  |  |  | Not Available | 0.00467289719626168 | 1 | 214
B-AT-TRN-01 |  |  |  |  | Not Available | 0.0545454545454545 | 6 | 110
B-AT-TRN-01 |  |  |  |  | Not Available | 0.477926714877909 | 15795 | 33049
B-AT-TRN-01 |  |  |  |  | Not Available | 0.0495495495495496 | 11 | 222
B-AT-TRN-01 |  |  |  |  | Pakistan | '-- | 1 | 0
B-AT-TRN-01 |  |  |  |  | TANZANIA, UNITED REPUBLIC OF | '-- | 2 | 0
B-AT-TRN-01 |  |  |  |  | Bangladesh | '-- | 1 | 0
B-AT-TRN-01 |  |  |  |  | China | '-- | 1 | 0
B-AT-TRN-01 |  |  |  |  | Hong Kong | '-- | 2 | 0
B-AT-TRN-01 |  |  |  |  | India | '-- | 16 | 0
B-AT-TRN-01 |  |  |  |  | Malaysia | '-- | 4 | 0
B-AT-TRN-01 |  |  |  |  | Singapore | '-- | 10 | 0
B-AT-TRN-01 |  |  |  |  | United Kingdom | '-- | 6 | 0
B-AT-TRN-01 |  |  |  |  | United States of America | '-- | 2 | 0
B-AT-TRN-01 |  |  |  |  | DUBAI INT FIN CENTRE (DIFC) | '-- | 2 | 0
B-AT-TRN-01 |  |  |  |  | Not Available | '-- | 1 | 0
B-AT-TRN-01 |  |  |  |  | Botswana | '-- | 1 | 0
B-AT-TRN-01 |  |  |  |  | Gambia | '-- | 0 | 0
B-AT-TRN-01 |  |  |  |  | Kenya | '-- | 0 | 0
B-AT-TRN-01 |  |  |  |  | Pakistan | '-- | 0 | 0
B-AT-TRN-01 |  |  |  |  | TANZANIA, UNITED REPUBLIC OF | '-- | 0 | 0
B-AT-TRN-01 |  |  |  |  | Zimbabwe | '-- | 0 | 0
B-AT-TRN-01 |  |  |  |  | Australia | '-- | 0 | 0
B-AT-TRN-01 |  |  |  |  | Bangladesh | '-- | 0 | 0
B-AT-TRN-01 |  |  |  |  | China | '-- | 1 | 0
B-AT-TRN-01 |  |  |  |  | Hong Kong | '-- | 0 | 0
B-AT-TRN-01 |  |  |  |  | India | '-- | 1 | 0
B-AT-TRN-01 |  |  |  |  | Macao | '-- | 0 | 0
B-AT-TRN-01 |  |  |  |  | Malaysia | '-- | 1 | 0
B-AT-TRN-01 |  |  |  |  | Singapore | '-- | 4 | 0
B-AT-TRN-01 |  |  |  |  | United Kingdom | '-- | 0 | 0
B-AT-TRN-01 |  |  |  |  | United States of America | '-- | 0 | 0
B-AT-TRN-01 |  |  |  |  | DUBAI INT FIN CENTRE (DIFC) | '-- | 0 | 0
B-AT-TRN-01 |  |  |  |  | Not Available | '-- | 0 | 0
B-AT-TRN-01 |  |  |  |  | Not Available | '-- | 0 | 0
B-AT-TRN-01 |  |  |  |  | Not Available | '-- | 0 | 0
B-AT-TRN-01 |  |  |  |  | Pakistan | 0 | 0 | 1
B-AT-TRN-01 |  |  |  |  | Bangladesh | 0 | 0 | 1
B-AT-TRN-01 |  |  |  |  | China | 0 | 0 | 3241
B-AT-TRN-01 |  |  |  |  | India | 0 | 0 | 25677
B-AT-TRN-01 |  |  |  |  | Malaysia | 0 | 0 | 4991
B-AT-TRN-01 |  |  |  |  | Nepal | 0 | 0 | 1
B-AT-TRN-01 |  |  |  |  | Philippines | 0 | 0 | 1
B-AT-TRN-01 |  |  |  |  | Singapore | 0 | 0 | 98
B-AT-TRN-01 |  |  |  |  | Vietnam | 0 | 0 | 1
B-AT-TRN-01 |  |  |  |  | Poland | 0 | 0 | 1267
B-AT-TRN-01 |  |  |  |  | United Kingdom | 0 | 0 | 12