Spreadsheet: 82481d1282564401-combine-2-sources-of-data-splits_ex
Sheet: Desired Results

Codes | Distributor | Split_Mkt Region | [NAME]
AAFA | Distributor A | France | 1.13
AAFA | Distributor A | Germany | 2.45
AAFA | Distributor A | Hong Kong | 8.83
AAFA | Distributor A | Italy | 0.07
AAFA | Distributor A | Japan | 0
AAFA | Distributor A | Spain | 6.66
AAFA | Distributor A | Switzerland | 77.6
AAFA | Distributor B | France | 4.06
AAFA | Distributor B | Germany | 3.84
AAFA | Distributor B | Hong Kong | 70.23
AAFA | Distributor B | Italy | 2.12
AAFA | Distributor B | Japan | 0.05
AAFA | Distributor B | Spain | 0.07
AAFA | Distributor B | Switzerland | 3.12
AAFA | Distributor C | France | 2.61
AAFA | Distributor C | Germany | 5.39
AAFA | Distributor C | Hong Kong | 0
AAFA | Distributor C | Italy | 13.54
AAFA | Distributor C | Japan | 25.84
AAFA | Distributor C | Spain | 0.07
AAFA | Distributor C | Switzerland | 3.34
AAFA | Distributor D | France | 0
AAFA | Distributor D | Germany | 0
AAFA | Distributor D | Hong Kong | 0
AAFA | Distributor D | Italy | 0
AAFA | Distributor D | Japan | 0
AAFA | Distributor D | Spain | 1.54
AAFA | Distributor D | Switzerland | 0.68
BNDB | Distributor A | France | 1.13
BNDB | Distributor A | Germany | 2.45
BNDB | Distributor A | Hong Kong | 8.83
BNDB | Distributor A | Italy | 0.07
BNDB | Distributor A | Japan | 0
BNDB | Distributor A | Spain | 6.66
BNDB | Distributor A | Switzerland | 77.6
BNDB | Distributor B | France | 4.06
BNDB | Distributor B | Germany | 3.84
BNDB | Distributor B | Hong Kong | 70.23
BNDB | Distributor B | Italy | 2.12
BNDB | Distributor B | Japan | 0.05
BNDB | Distributor B | Spain | 0.07
BNDB | Distributor B | Switzerland | 3.12
BNDB | Distributor C | France | 2.61
BNDB | Distributor C | Germany | 5.39
BNDB | Distributor C | Hong Kong | 0
BNDB | Distributor C | Italy | 13.54
BNDB | Distributor C | Japan | 25.84
BNDB | Distributor C | Spain | 0.07
BNDB | Distributor C | Switzerland | 3.34
BNDB | Distributor D | France | 0
BNDB | Distributor D | Germany | 0
BNDB | Distributor D | Hong Kong | 0
BNDB | Distributor D | Italy | 0
BNDB | Distributor D | Japan | 0
BNDB | Distributor D | Spain | 1.54
BNDB | Distributor D | Switzerland | 0.68
BRAN | Distributor A | France | 1.13
BRAN | Distributor A | Germany | 2.45
BRAN | Distributor A | Hong Kong | 8.83
BRAN | Distributor A | Italy | 0.07
BRAN | Distributor A | Japan | 0
BRAN | Distributor A | Spain | 6.66
BRAN | Distributor A | Switzerland | 77.6
BRAN | Distributor B | France | 4.06
BRAN | Distributor B | Germany | 3.84
BRAN | Distributor B | Hong Kong | 70.23
BRAN | Distributor B | Italy | 2.12
BRAN | Distributor B | Japan | 0.05
BRAN | Distributor B | Spain | 0.07
BRAN | Distributor B | Switzerland | 3.12
BRAN | Distributor C | France | 2.61
BRAN | Distributor C | Germany | 5.39
BRAN | Distributor C | Hong Kong | 0
BRAN | Distributor C | Italy | 13.54
BRAN | Distributor C | Japan | 25.84
BRAN | Distributor C | Spain | 0.07
BRAN | Distributor C | Switzerland | 3.34
BRAN | Distributor D | France | 0
BRAN | Distributor D | Germany | 0
BRAN | Distributor D | Hong Kong | 0
BRAN | Distributor D | Italy | 0
BRAN | Distributor D | Japan | 0
BRAN | Distributor D | Spain | 1.54
BRAN | Distributor D | Switzerland | 0.68
CSFS | Distributor A | France | 1.13
CSFS | Distributor A | Germany | 2.45
CSFS | Distributor A | Hong Kong | 8.83
CSFS | Distributor A | Italy | 0.07
CSFS | Distributor A | Japan | 0
CSFS | Distributor A | Spain | 6.66
CSFS | Distributor A | Switzerland | 77.6
CSFS | Distributor B | France | 4.06
CSFS | Distributor B | Germany | 3.84
CSFS | Distributor B | Hong Kong | 70.23
CSFS | Distributor B | Italy | 2.12
CSFS | Distributor B | Japan | 0.05
CSFS | Distributor B | Spain | 0.07
CSFS | Distributor B | Switzerland | 3.12
CSFS | Distributor C | France | 2.61
CSFS | Distributor C | Germany | 5.39
CSFS | Distributor C | Hong Kong | 0
CSFS | Distributor C | Italy | 13.54
CSFS | Distributor C | Japan | 25.84
CSFS | Distributor C | Spain | 0.07
CSFS | Distributor C | Switzerland | 3.34
CSFS | Distributor D | France | 0
CSFS | Distributor D | Germany | 0
CSFS | Distributor D | Hong Kong | 0
CSFS | Distributor D | Italy | 0
CSFS | Distributor D | Japan | 0
CSFS | Distributor D | Spain | 1.54
CSFS | Distributor D | Switzerland | 0.68
CSFI | Distributor A | France | 1.13
CSFI | Distributor A | Germany | 2.45
CSFI | Distributor A | Hong Kong | 8.83
CSFI | Distributor A | Italy | 0.07
CSFI | Distributor A | Japan | 0
CSFI | Distributor A | Spain | 6.66
CSFI | Distributor A | Switzerland | 77.6
CSFI | Distributor B | France | 4.06
CSFI | Distributor B | Germany | 3.84
CSFI | Distributor B | Hong Kong | 70.23
CSFI | Distributor B | Italy | 2.12
CSFI | Distributor B | Japan | 0.05
CSFI | Distributor B | Spain | 0.07
CSFI | Distributor B | Switzerland | 3.12
CSFI | Distributor C | France | 2.61
CSFI | Distributor C | Germany | 5.39
CSFI | Distributor C | Hong Kong | 0
CSFI | Distributor C | Italy | 13.54
CSFI | Distributor C | Japan | 25.84
CSFI | Distributor C | Spain | 0.07
CSFI | Distributor C | Switzerland | 3.34
CSFI | Distributor D | France | 0
CSFI | Distributor D | Germany | 0
CSFI | Distributor D | Hong Kong | 0
CSFI | Distributor D | Italy | 0
CSFI | Distributor D | Japan | 0
CSFI | Distributor D | Spain | 1.54
CSFI | Distributor D | Switzerland | 0.68
DREF | Distributor A | France | 1.13
DREF | Distributor A | Germany | 2.45
DREF | Distributor A | Hong Kong | 8.83
DREF | Distributor A | Italy | 0.07
DREF | Distributor A | Japan | 0
DREF | Distributor A | Spain | 6.66
DREF | Distributor A | Switzerland | 77.6
DREF | Distributor B | France | 4.06
DREF | Distributor B | Germany | 3.84
DREF | Distributor B | Hong Kong | 70.23
DREF | Distributor B | Italy | 2.12
DREF | Distributor B | Japan | 0.05
DREF | Distributor B | Spain | 0.07
DREF | Distributor B | Switzerland | 3.12
DREF | Distributor C | France | 2.61
DREF | Distributor C | Germany | 5.39
DREF | Distributor C | Hong Kong | 0
DREF | Distributor C | Italy | 13.54
DREF | Distributor C | Japan | 25.84
DREF | Distributor C | Spain | 0.07
DREF | Distributor C | Switzerland | 3.34
DREF | Distributor D | France | 0
DREF | Distributor D | Germany | 0
DREF | Distributor D | Hong Kong | 0
DREF | Distributor D | Italy | 0
DREF | Distributor D | Japan | 0
DREF | Distributor D | Spain | 1.54
DREF | Distributor D | Switzerland | 0.68
ECD | Distributor A | France | 1.13
ECD | Distributor A | Germany | 2.45
ECD | Distributor A | Hong Kong | 8.83
ECD | Distributor A | Italy | 0.07
ECD | Distributor A | Japan | 0
ECD | Distributor A | Spain | 6.66
ECD | Distributor A | Switzerland | 77.6
ECD | Distributor B | France | 4.06
ECD | Distributor B | Germany | 3.84
ECD | Distributor B | Hong Kong | 70.23
ECD | Distributor B | Italy | 2.12
ECD | Distributor B | Japan | 0.05
ECD | Distributor B | Spain | 0.07
ECD | Distributor B | Switzerland | 3.12
ECD | Distributor C | France | 2.61
ECD | Distributor C | Germany | 5.39
ECD | Distributor C | Hong Kong | 0
ECD | Distributor C | Italy | 13.54
ECD | Distributor C | Japan | 25.84
ECD | Distributor C | Spain | 0.07
ECD | Distributor C | Switzerland | 3.34
ECD | Distributor D | France | 0
ECD | Distributor D | Germany | 0
ECD | Distributor D | Hong Kong | 0
ECD | Distributor D | Italy | 0
ECD | Distributor D | Japan | 0
ECD | Distributor D | Spain | 1.54
ECD | Distributor D | Switzerland | 0.68
ECDO | Distributor A | France | 1.13
ECDO | Distributor A | Germany | 2.45
ECDO | Distributor A | Hong Kong | 8.83
ECDO | Distributor A | Italy | 0.07
ECDO | Distributor A | Japan | 0
ECDO | Distributor A | Spain | 6.66
ECDO | Distributor A | Switzerland | 77.6
ECDO | Distributor B | France | 4.06
ECDO | Distributor B | Germany | 3.84
ECDO | Distributor B | Hong Kong | 70.23
ECDO | Distributor B | Italy | 2.12
ECDO | Distributor B | Japan | 0.05
ECDO | Distributor B | Spain | 0.07
ECDO | Distributor B | Switzerland | 3.12
ECDO | Distributor C | France | 2.61
ECDO | Distributor C | Germany | 5.39
ECDO | Distributor C | Hong Kong | 0
ECDO | Distributor C | Italy | 13.54
ECDO | Distributor C | Japan | 25.84
ECDO | Distributor C | Spain | 0.07
ECDO | Distributor C | Switzerland | 3.34
ECDO | Distributor D | France | 0
ECDO | Distributor D | Germany | 0
ECDO | Distributor D | Hong Kong | 0
ECDO | Distributor D | Italy | 0
ECDO | Distributor D | Japan | 0
ECDO | Distributor D | Spain | 1.54
ECDO | Distributor D | Switzerland | 0.68
GCB | Distributor A | France | 1.13
GCB | Distributor A | Germany | 2.45
GCB | Distributor A | Hong Kong | 8.83
GCB | Distributor A | Italy | 0.07
GCB | Distributor A | Japan | 0
GCB | Distributor A | Spain | 6.66
GCB | Distributor A | Switzerland | 77.6
GCB | Distributor B | France | 4.06
GCB | Distributor B | Germany | 3.84
GCB | Distributor B | Hong Kong | 70.23
GCB | Distributor B | Italy | 2.12
GCB | Distributor B | Japan | 0.05
GCB | Distributor B | Spain | 0.07
GCB | Distributor B | Switzerland | 3.12
GCB | Distributor C | France | 2.61
GCB | Distributor C | Germany | 5.39
GCB | Distributor C | Hong Kong | 0
GCB | Distributor C | Italy | 13.54
GCB | Distributor C | Japan | 25.84
GCB | Distributor C | Spain | 0.07
GCB | Distributor C | Switzerland | 3.34
GCB | Distributor D | France | 0
GCB | Distributor D | Germany | 0
GCB | Distributor D | Hong Kong | 0
GCB | Distributor D | Italy | 0
GCB | Distributor D | Japan | 0
GCB | Distributor D | Spain | 1.54
GCB | Distributor D | Switzerland | 0.68
HLT | Distributor A | France | 1.13
HLT | Distributor A | Germany | 2.45
HLT | Distributor A | Hong Kong | 8.83
HLT | Distributor A | Italy | 0.07
HLT | Distributor A | Japan | 0
HLT | Distributor A | Spain | 6.66
HLT | Distributor A | Switzerland | 77.6
HLT | Distributor B | France | 4.06
HLT | Distributor B | Germany | 3.84
HLT | Distributor B | Hong Kong | 70.23
HLT | Distributor B | Italy | 2.12
HLT | Distributor B | Japan | 0.05
HLT | Distributor B | Spain | 0.07
HLT | Distributor B | Switzerland | 3.12
HLT | Distributor C | France | 2.61
HLT | Distributor C | Germany | 5.39
HLT | Distributor C | Hong Kong | 0
HLT | Distributor C | Italy | 13.54
HLT | Distributor C | Japan | 25.84
HLT | Distributor C | Spain | 0.07
HLT | Distributor C | Switzerland | 3.34
HLT | Distributor D | France | 0
HLT | Distributor D | Germany | 0
HLT | Distributor D | Hong Kong | 0
HLT | Distributor D | Italy | 0
HLT | Distributor D | Japan | 0
HLT | Distributor D | Spain | 1.54
HLT | Distributor D | Switzerland | 0.68
LEISC | Distributor A | France | 1.13
LEISC | Distributor A | Germany | 2.45
LEISC | Distributor A | Hong Kong | 8.83
LEISC | Distributor A | Italy | 0.07
LEISC | Distributor A | Japan | 0
LEISC | Distributor A | Spain | 6.66
LEISC | Distributor A | Switzerland | 77.6
LEISC | Distributor B | France | 4.06
LEISC | Distributor B | Germany | 3.84
LEISC | Distributor B | Hong Kong | 70.23
LEISC | Distributor B | Italy | 2.12
LEISC | Distributor B | Japan | 0.05
LEISC | Distributor B | Spain | 0.07
LEISC | Distributor B | Switzerland | 3.12
LEISC | Distributor C | France | 2.61
LEISC | Distributor C | Germany | 5.39
LEISC | Distributor C | Hong Kong | 0
LEISC | Distributor C | Italy | 13.54
LEISC | Distributor C | Japan | 25.84
LEISC | Distributor C | Spain | 0.07
LEISC | Distributor C | Switzerland | 3.34
LEISC | Distributor D | France | 0
LEISC | Distributor D | Germany | 0
LEISC | Distributor D | Hong Kong | 0
LEISC | Distributor D | Italy | 0
LEISC | Distributor D | Japan | 0
LEISC | Distributor D | Spain | 1.54
LEISC | Distributor D | Switzerland | 0.68
LEISE | Distributor A | France | 1.13
LEISE | Distributor A | Germany | 2.45
LEISE | Distributor A | Hong Kong | 8.83
LEISE | Distributor A | Italy | 0.07
LEISE | Distributor A | Japan | 0
LEISE | Distributor A | Spain | 6.66
LEISE | Distributor A | Switzerland | 77.6
LEISE | Distributor B | France | 4.06
LEISE | Distributor B | Germany | 3.84
LEISE | Distributor B | Hong Kong | 70.23
LEISE | Distributor B | Italy | 2.12
LEISE | Distributor B | Japan | 0.05
LEISE | Distributor B | Spain | 0.07
LEISE | Distributor B | Switzerland | 3.12
LEISE | Distributor C | France | 2.61
LEISE | Distributor C | Germany | 5.39
LEISE | Distributor C | Hong Kong | 0
LEISE | Distributor C | Italy | 13.54
LEISE | Distributor C | Japan | 25.84
LEISE | Distributor C | Spain | 0.07
LEISE | Distributor C | Switzerland | 3.34
LEISE | Distributor D | France | 0
LEISE | Distributor D | Germany | 0
LEISE | Distributor D | Hong Kong | 0
LEISE | Distributor D | Italy | 0
LEISE | Distributor D | Japan | 0
LEISE | Distributor D | Spain | 1.54
LEISE | Distributor D | Switzerland | 0.68
NIPE | Distributor A | France | 1.13
NIPE | Distributor A | Germany | 2.45
NIPE | Distributor A | Hong Kong | 8.83
NIPE | Distributor A | Italy | 0.07
NIPE | Distributor A | Japan | 0
NIPE | Distributor A | Spain | 6.66
NIPE | Distributor A | Switzerland | 77.6
NIPE | Distributor B | France | 4.06
NIPE | Distributor B | Germany | 3.84
NIPE | Distributor B | Hong Kong | 70.23
NIPE | Distributor B | Italy | 2.12
NIPE | Distributor B | Japan | 0.05
NIPE | Distributor B | Spain | 0.07
NIPE | Distributor B | Switzerland | 3.12
NIPE | Distributor C | France | 2.61
NIPE | Distributor C | Germany | 5.39
NIPE | Distributor C | Hong Kong | 0
NIPE | Distributor C | Italy | 13.54
NIPE | Distributor C | Japan | 25.84
NIPE | Distributor C | Spain | 0.07
NIPE | Distributor C | Switzerland | 3.34
NIPE | Distributor D | France | 0
NIPE | Distributor D | Germany | 0
NIPE | Distributor D | Hong Kong | 0
NIPE | Distributor D | Italy | 0
NIPE | Distributor D | Japan | 0
NIPE | Distributor D | Spain | 1.54
NIPE | Distributor D | Switzerland | 0.68
PAME | Distributor A | France | 1.13
PAME | Distributor A | Germany | 2.45
PAME | Distributor A | Hong Kong | 8.83
PAME | Distributor A | Italy | 0.07
PAME | Distributor A | Japan | 0
PAME | Distributor A | Spain | 6.66
PAME | Distributor A | Switzerland | 77.6
PAME | Distributor B | France | 4.06
PAME | Distributor B | Germany | 3.84
PAME | Distributor B | Hong Kong | 70.23
PAME | Distributor B | Italy | 2.12
PAME | Distributor B | Japan | 0.05
PAME | Distributor B | Spain | 0.07
PAME | Distributor B | Switzerland | 3.12
PAME | Distributor C | France | 2.61
PAME | Distributor C | Germany | 5.39
PAME | Distributor C | Hong Kong | 0
PAME | Distributor C | Italy | 13.54
PAME | Distributor C | Japan | 25.84
PAME | Distributor C | Spain | 0.07
PAME | Distributor C | Switzerland | 3.34
PAME | Distributor D | France | 0
PAME | Distributor D | Germany | 0
PAME | Distributor D | Hong Kong | 0
PAME | Distributor D | Italy | 0
PAME | Distributor D | Japan | 0
PAME | Distributor D | Spain | 1.54
PAME | Distributor D | Switzerland | 0.68
STBA | Distributor A | France | 1.13
STBA | Distributor A | Germany | 2.45
STBA | Distributor A | Hong Kong | 8.83
STBA | Distributor A | Italy | 0.07
STBA | Distributor A | Japan | 0
STBA | Distributor A | Spain | 6.66
STBA | Distributor A | Switzerland | 77.6
STBA | Distributor B | France | 4.06
STBA | Distributor B | Germany | 3.84
STBA | Distributor B | Hong Kong | 70.23
STBA | Distributor B | Italy | 2.12
STBA | Distributor B | Japan | 0.05
STBA | Distributor B | Spain | 0.07
STBA | Distributor B | Switzerland | 3.12
STBA | Distributor C | France | 2.61
STBA | Distributor C | Germany | 5.39
STBA | Distributor C | Hong Kong | 0
STBA | Distributor C | Italy | 13.54
STBA | Distributor C | Japan | 25.84
STBA | Distributor C | Spain | 0.07
STBA | Distributor C | Switzerland | 3.34
STBA | Distributor D | France | 0
STBA | Distributor D | Germany | 0
STBA | Distributor D | Hong Kong | 0
STBA | Distributor D | Italy | 0
STBA | Distributor D | Japan | 0
STBA | Distributor D | Spain | 1.54
STBA | Distributor D | Switzerland | 0.68
TELR | Distributor A | France | 1.13
TELR | Distributor A | Germany | 2.45
TELR | Distributor A | Hong Kong | 8.83
TELR | Distributor A | Italy | 0.07
TELR | Distributor A | Japan | 0
TELR | Distributor A | Spain | 6.66
TELR | Distributor A | Switzerland | 77.6
TELR | Distributor B | France | 4.06
TELR | Distributor B | Germany | 3.84
TELR | Distributor B | Hong Kong | 70.23
TELR | Distributor B | Italy | 2.12
TELR | Distributor B | Japan | 0.05
TELR | Distributor B | Spain | 0.07
TELR | Distributor B | Switzerland | 3.12
TELR | Distributor C | France | 2.61
TELR | Distributor C | Germany | 5.39
TELR | Distributor C | Hong Kong | 0
TELR | Distributor C | Italy | 13.54
TELR | Distributor C | Japan | 25.84
TELR | Distributor C | Spain | 0.07
TELR | Distributor C | Switzerland | 3.34
TELR | Distributor D | France | 0
TELR | Distributor D | Germany | 0
TELR | Distributor D | Hong Kong | 0
TELR | Distributor D | Italy | 0
TELR | Distributor D | Japan | 0
TELR | Distributor D | Spain | 1.54
TELR | Distributor D | Switzerland | 0.68
USEP | Distributor A | France | 1.13
USEP | Distributor A | Germany | 2.45
USEP | Distributor A | Hong Kong | 8.83
USEP | Distributor A | Italy | 0.07
USEP | Distributor A | Japan | 0
USEP | Distributor A | Spain | 6.66
USEP | Distributor A | Switzerland | 77.6
USEP | Distributor B | France | 4.06
USEP | Distributor B | Germany | 3.84
USEP | Distributor B | Hong Kong | 70.23
USEP | Distributor B | Italy | 2.12
USEP | Distributor B | Japan | 0.05
USEP | Distributor B | Spain | 0.07
USEP | Distributor B | Switzerland | 3.12
USEP | Distributor C | France | 2.61
USEP | Distributor C | Germany | 5.39
USEP | Distributor C | Hong Kong | 0
USEP | Distributor C | Italy | 13.54
USEP | Distributor C | Japan | 25.84
USEP | Distributor C | Spain | 0.07
USEP | Distributor C | Switzerland | 3.34
USEP | Distributor D | France | 0
USEP | Distributor D | Germany | 0
USEP | Distributor D | Hong Kong | 0
USEP | Distributor D | Italy | 0
USEP | Distributor D | Japan | 0
USEP | Distributor D | Spain | 1.54
USEP | Distributor D | Switzerland | 0.68
USEA | Distributor A | France | 1.13
USEA | Distributor A | Germany | 2.45
USEA | Distributor A | Hong Kong | 8.83
USEA | Distributor A | Italy | 0.07
USEA | Distributor A | Japan | 0
USEA | Distributor A | Spain | 6.66
USEA | Distributor A | Switzerland | 77.6
USEA | Distributor B | France | 4.06
USEA | Distributor B | Germany | 3.84
USEA | Distributor B | Hong Kong | 70.23
USEA | Distributor B | Italy | 2.12
USEA | Distributor B | Japan | 0.05
USEA | Distributor B | Spain | 0.07
USEA | Distributor B | Switzerland | 3.12
USEA | Distributor C | France | 2.61
USEA | Distributor C | Germany | 5.39
USEA | Distributor C | Hong Kong | 0
USEA | Distributor C | Italy | 13.54
USEA | Distributor C | Japan | 25.84
USEA | Distributor C | Spain | 0.07
USEA | Distributor C | Switzerland | 3.34
USEA | Distributor D | France | 0
USEA | Distributor D | Germany | 0
USEA | Distributor D | Hong Kong | 0
USEA | Distributor D | Italy | 0
USEA | Distributor D | Japan | 0
USEA | Distributor D | Spain | 1.54
USEA | Distributor D | Switzerland | 0.68