Spreadsheet: 888992d1739636454-groupby-formula-using-choosecol-instead-of-hstack-groupby-choose-columns
Sheet: PROCESS

Facture | Origine | Origine | Nomenclature | EAN13 | ITM8 | Libellé | TARIFF NO | [NAME] | PACK SIZE DESCRIPTION | ORIGIN | PACK SIZE DESCRIPTION2 | PACKS | PER PACKS | LITRAGE | [NAME] | SUGAR G/L | % ALCOHOL | QTY | LITRES | SUGAR | ALCOHOL | Cndt | [NAME] | Qté | Prix Unit | Montant HT | CHARGES | Total Fob Eur
ZZZZ | France | NON | ASSSRRR | AS | 29058400 | RTTT | 22021012 | ENERGY DRINKS CAN | 1*24*50CL | FR |  | 1 | 24 | 50 | 0.5 | 34 |  | 24 | 12 | 816 |  | 24 | 1 | 24 | 0.496 | 11.9 | 0.06724191085463001 | 11.96724191085463
ZZZZ | France | NON | ASSSRRR | AS | 52302035 | RTTT | 22021011 | AERATED JUICES | 4*6*1.5L | FR |  | 4 | 6 | 1.5 | 1.5 | 80 |  | 24 | 36 | 1920 |  | 6 | 4 | 24 | 0.777 | 18.65 | 0.1053833308772142 | 18.75538333087721
ZZZZ | France |  | ASSSRRR | AS | 41027126 | RTTT | 19053110 | BISCUITS |  | FR |  |  |  |  |  |  |  | 48 |  |  |  | 24 | 2 | 48 | 1.108 | 53.18 | 0.300497883970523 | 53.48049788397052
ZZZZ | France | W | ASSSRRR | AS | 41027091 | RTTT | 19053110 | BISCUITS. |  | FR |  |  |  |  |  |  |  | 264 |  |  |  | 24 | 11 | 264 | 0.983 | 259.51 | 1.466382208897902 | 260.9763822088979
ZZZZ | France | W | ASSSRRR | AS | 41027089 | RTTT | 19053110 | BISCUITS |  | FR |  |  |  |  |  |  |  | 20 |  |  |  | 10 | 2 | 20 | 1.624 | 32.48 | 0.1835308625679313 | 32.66353086256793
ZZZZ | France | W | ASSSRRR | AS | 41027415 | RTTT | 19053110 | BISCUITS |  | FR |  |  |  |  |  |  |  | 348 |  |  |  | 12 | 29 | 348 | 0.759 | 264.13 | 1.492487891935582 | 265.6224878919356
ZZZZ | France | W | ASSSRRR | AS | 41027200 | RTTT | 19053110 | BISCUITS |  | FR |  |  |  |  |  |  |  | 126 |  |  |  | 18 | 7 | 126 | 1.149 | 144.77 | 0.8180345743214106 | 145.5880345743214
ZZZZ | Belgique | NON | ASSSRRR | AS | 41029001 | RTTT | 19053110 | BISCUITS |  | BE |  |  |  |  |  |  |  | 180 |  |  |  | 12 | 15 | 180 | 2.683 | 482.94 | 2.72889146454916 | 485.6688914645492
ZZZZ | France | W | ASSSRRR | AS | 41026020 | RTTT | 19053110 | BISCUITS |  | FR |  |  |  |  |  |  |  | 130 |  |  |  | 10 | 13 | 130 | 1.711 | 222.43 | 1.256858674907172 | 223.6868586749072
ZZZZ | Pays-Bas | NON | ASSSRRR | AS | 41027155 | RTTT | 19053110 | BISCUITS |  | NL |  |  |  |  |  |  |  | 12 |  |  |  | 12 | 1 | 12 | 0.86 | 10.32 | 0.05831399327897325 | 10.37831399327897
ZZZZ | France | NON | ASSSRRR | AS | 52303129 | RTTT | 20099000 | [NAME] | 20*6*20CL | FR |  | 20 | 6 | 20 | 0.2 | 85 |  | 120 | 24 | 10200 |  | 4 | 5 | 20 | 1.269 | 25.38 | 0.1434117392849168 | 25.52341173928492
ZZZZ | France | W | ASSSRRR | AS | 41027109 | RTTT | 19053110 | BISCUITS |  | FR |  |  |  |  |  |  |  | 72 |  |  |  | 12 | 6 | 72 | 1.054 | 75.89 | 0.4288225726687286 | 76.31882257266872
ZZZZ | France | W | ASSSRRR | AS | 41026142 | RTTT | 19053110 | BISCUITS. |  | FR |  |  |  |  |  |  |  | 24 |  |  |  | 12 | 2 | 24 | 1.205 | 28.92 | 0.1634147951189832 | 29.08341479511898
ZZZZ | France | W | ASSSRRR | AS | 41023024 | RTTT | 19053110 | BISCUITS |  | FR |  |  |  |  |  |  |  | 60 |  |  |  | 12 | 5 | 60 | 0.886 | 53.16 | 0.3003848723556412 | 53.46038487235564
ZZZZ | France | NON | ASSSRRR | AS | 17126445 | RTTT | 19054091 | TOASTED BREAD |  | FR |  |  |  |  |  |  |  | 84 |  |  |  | 12 | 7 | 84 | 1.875 | 157.5 | 0.8899664671936324 | 158.3899664671936
ZZZZ | France | NON | ASSSRRR | AS | 17134452 | RTTT | 19053110 | BISCUITS |  | FR |  |  |  |  |  |  |  | 56 |  |  |  | 14 | 4 | 56 | 1.351 | 75.66 | 0.4275229390975887 | 76.08752293909758
ZZZZ | France | W | ASSSRRR | AS | 17144281 | RTTT | 19053110 | BISCUITS |  | FR |  |  |  |  |  |  |  | 96 |  |  |  | 12 | 8 | 96 | 1.499 | 143.9 | 0.8131185690740552 | 144.7131185690741
ZZZZ | France | W | ASSSRRR | AS | 17144286 | RTTT | 19053110 | BISCUITS |  | FR |  |  |  |  |  |  |  | 12 |  |  |  | 12 | 1 | 12 | 1.305 | 15.66 | 0.08848809445239544 | 15.7484880944524