Spreadsheet: 843880d1695710662-dynamic-array-formula-for-irregular-data-book2
Sheet: Sheet1

 | Dataset ID | Dataset | Channel Name | Division | Sizebow Selector | Size #1 | Size #2 | Size #3 | Size #4 | Size #5 | Size #6 | Size #7 | Size #8 |  |  | Name | TALL %
1 | 1 | [NAME] |  |  | Kids | 92 | 98 | 104 | 110 |  | h |  |  |  |  | Polo | Size | XS | S | M | L | XL | XXL |  |  | Total
1EU Offline |  |  | EU Offline | Kids | z |  | 0.2 | 0.2 | 0.2 | 0.2 | 0 | 0 | 0 |  | PoloNL |  | NL | 0.03 | 0.109 | 0.111 | 0.32 | 0.25 | 0.18 |  |  | 1
1Online |  |  | Online | Kids | z | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0 | 0 | 0 |  | PoloD |  | D | 0.03 | 0.109 | 0.111 | 0.32 | 0.25 | 0.18 |  |  | 1
1Langenhagen |  |  | Langenhagen | Kids |  |  |  |  |  |  |  |  |  |  | PoloB |  | B | 0.03 | 0.109 | 0.111 | 0.32 | 0.25 | 0.18 |  |  | 1
1Poznan |  |  | Poznan | Kids |  |  |  |  |  |  |  |  |  |  | PoloF |  | F | 0.03 | 0.109 | 0.111 | 0.32 | 0.25 | 0.18 |  |  | 1
1Empty |  |  | Empty | Kids |  |  |  |  |  |  |  |  |  |  | PoloCH |  | CH | 0.03 | 0.109 | 0.111 | 0.32 | 0.25 | 0.18 |  |  | 1
1Zalando |  |  | Zalando | Kids | z | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0 | 0 | 0 |  | PoloE |  | E | 0.03 | 0.109 | 0.111 | 0.32 | 0.25 | 0.18 |  |  | 1
1Amazon |  |  | Amazon | Kids | z | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0 | 0 | 0 |  | PoloA |  | A | 0.03 | 0.109 | 0.111 | 0.32 | 0.25 | 0.18 |  |  | 1
1Dreambaby |  |  | [NAME] | Kids |  |  |  |  |  |  |  |  |  |  | PoloSK |  | SK | 0.03 | 0.109 | 0.111 | 0.32 | 0.25 | 0.18 |  |  | 1
1Empty 2 |  |  | Empty 2 | Kids | z | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0 | 0 | 0 |  | PoloEU Offline |  | EU Offline | 0.03 | 0.109 | 0.111 | 0.32 | 0.25 | 0.18 |  |  | 1
1Wehkamp |  |  | Wehkamp | Kids | z | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0 | 0 | 0 |  | PoloOnline |  | Online | 0.03 | 0.109 | 0.111 | 0.32 | 0.25 | 0.18 |  |  | 1
2 | 2 | B0F438A395484500B03D186EC5E48C8C |  |  | Kids | 92 | 98 | 104 | 110 |  |  |  |  |  | PoloZalando |  | Zalando | 0.03 | 0.109 | 0.111 | 0.32 | 0.25 | 0.18 |  |  | 1
2EU Offline |  |  | EU Offline | Kids |  |  | 0.2 | 0.2 | 0.2 | 0.2 | 0 | 0 | 0 |  | PoloAmazon |  | Amazon | 0.03 | 0.109 | 0.111 | 0.32 | 0.25 | 0.18 |  |  | 1
2Online |  |  | Online | Kids |  | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0 | 0 | 0 |  | PoloWEHKAMP |  | WEHKAMP | 0.03 | 0.109 | 0.111 | 0.32 | 0.25 | 0.18 |  |  | 1
2Langenhagen |  |  | Langenhagen | Kids |  |  |  |  |  |  |  |  |  |  | PoloEmpty 1 |  | Empty 1 |  |  |  |  |  |  |  |  | 0
2Poznan |  |  | Poznan | Kids |  |  |  |  |  |  |  |  |  |  | PoloEmpty 2 |  | Empty 2 |  |  |  |  |  |  |  |  | 0
2Empty |  |  | Empty | Kids
2Zalando |  |  | Zalando | Kids |  | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0 | 0 | 0 |  |  | Name | TALL %
2Amazon |  |  | Amazon | Kids |  | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0 | 0 | 0 |  |  | T-Shirt 6 | Size | XS | S | M | L | XL | XXL |  |  | Total
2Dreambaby |  |  | [NAME] | Kids |  |  |  |  |  |  |  |  |  |  | T-Shirt 6NL |  | NL | 0.07 | 0.12 | 0.22 | 0.24 | 0.2 | 0.15 |  |  | 1
2Empty 2 |  |  | Empty 2 | Kids |  | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0 | 0 | 0 |  | T-Shirt 6D |  | D | 0.1 | 0.13 | 0.2 | 0.24 | 0.18 | 0.15 |  |  | 1
2Wehkamp |  |  | Wehkamp | Kids |  | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0 | 0 | 0 |  | T-Shirt 6B |  | B | 0.1 | 0.13 | 0.2 | 0.24 | 0.18 | 0.15 |  |  | 1
3 | 3 | 924CC10D5A6745598A3DF6C316493599 |  |  | Polo | XS | S | M | L |  |  |  |  |  | T-Shirt 6F |  | F | 0.13 | 0.15 | 0.22 | 0.22 | 0.16 | 0.12 |  |  | 1
[NAME] |  |  | EU Offline | Kids |  |  |  |  |  |  |  |  |  |  | T-Shirt 6CH |  | CH | 0.12 | 0.14 | 0.21 | 0.23 | 0.17 | 0.13 |  |  | 1
3Online |  |  | Online | Kids |  |  |  |  |  |  |  |  |  |  | T-Shirt 6E |  | E | 0.11 | 0.13 | 0.2 | 0.23 | 0.18 | 0.15 |  |  | 1
3Langenhagen |  |  | Langenhagen | Kids |  |  |  |  |  |  |  |  |  |  | T-Shirt 6A |  | A | 0.08 | 0.13 | 0.2 | 0.25 | 0.19 | 0.15 |  |  | 1
3Poznan |  |  | Poznan | Kids |  |  |  |  |  |  |  |  |  |  | T-Shirt 6SK |  | SK | 0.09 | 0.13 | 0.2 | 0.25 | 0.18 | 0.15 |  |  | 1
3Empty |  |  | Empty | Kids |  |  |  |  |  |  |  |  |  |  | T-Shirt 6EU Offline |  | EU Offline | 0.1 | 0.13 | 0.2 | 0.24 | 0.18 | 0.15 |  |  | 1
3Zalando |  |  | Zalando | Kids |  |  |  |  |  |  |  |  |  |  | T-Shirt 6Online |  | Online | 0.1 | 0.13 | 0.2 | 0.24 | 0.18 | 0.15 |  |  | 1
3Amazon |  |  | Amazon | Kids |  |  |  |  |  |  |  |  |  |  | T-Shirt 6Zalando |  | Zalando | 0.1 | 0.13 | 0.2 | 0.24 | 0.18 | 0.15 |  |  | 1
3Dreambaby |  |  | [NAME] | Kids |  |  |  |  |  |  |  |  |  |  | T-Shirt 6Amazon |  | Amazon | 0.1 | 0.13 | 0.2 | 0.24 | 0.18 | 0.15 |  |  | 1
3Empty 2 |  |  | Empty 2 | Kids |  |  |  |  |  |  |  |  |  |  | T-Shirt 6WEHKAMP |  | WEHKAMP | 0.1 | 0.13 | 0.2 | 0.24 | 0.18 | 0.15 |  |  | 1
3Wehkamp |  |  | Wehkamp | Kids |  |  |  |  |  |  |  |  |  |  | T-Shirt 6Empty 1 |  | Empty 1 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T-Shirt 6Empty 2 |  | Empty 2 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name | TALL %
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T-Shirt 5 | Size | XS | S | M | L | XL |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T-Shirt 5NL |  | NL | 0.08 | 0.12 | 0.27 | 0.28 | 0.25 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T-Shirt 5D |  | D | 0.08 | 0.12 | 0.27 | 0.28 | 0.25 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T-Shirt 5B |  | B | 0.08 | 0.12 | 0.27 | 0.28 | 0.25 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T-Shirt 5F |  | F | 0.08 | 0.12 | 0.27 | 0.28 | 0.25 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T-Shirt 5CH |  | CH | 0.08 | 0.12 | 0.27 | 0.28 | 0.25 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T-Shirt 5E |  | E | 0.08 | 0.12 | 0.27 | 0.28 | 0.25 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T-Shirt 5A |  | A | 0.08 | 0.12 | 0.27 | 0.28 | 0.25 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T-Shirt 5SK |  | SK | 0.08 | 0.12 | 0.27 | 0.28 | 0.25 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T-Shirt 5EU Offline |  | EU Offline | 0.08 | 0.12 | 0.27 | 0.28 | 0.25 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T-Shirt 5Online |  | Online | 0.08 | 0.12 | 0.27 | 0.28 | 0.25 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T-Shirt 5Zalando |  | Zalando | 0.08 | 0.12 | 0.27 | 0.28 | 0.25 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T-Shirt 5Amazon |  | Amazon | 0.08 | 0.12 | 0.27 | 0.28 | 0.25 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T-Shirt 5WEHKAMP |  | WEHKAMP | 0.08 | 0.12 | 0.27 | 0.28 | 0.25 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T-Shirt 5Empty 1 |  | Empty 1 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T-Shirt 5Empty 2 |  | Empty 2 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name | TALL %
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kids | Size | 92 | 98 | 104 | 110 | 116 |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KidsNL |  | NL | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KidsD |  | D | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | B | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | F | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KidsCH |  | CH | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KidsE |  | E | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KidsA |  | A | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | SK | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KidsEU Offline |  | EU Offline | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KidsOnline |  | Online | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KidsZalando |  | Zalando | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KidsAmazon |  | Amazon | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KidsWEHKAMP |  | WEHKAMP | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KidsEmpty 1 |  | Empty 1 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KidsEmpty 2 |  | Empty 2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 |  |  |  | 1