Spreadsheet: 536465d1504525080-how-to-remove-the-word-blank-in-pivot-table-pivot-table-test
Sheet: PVTABLE

Tariff No | Description | SADC | Origin | Packing | Litres | Sugar | Reserve % alcohol | Sum of Qty_1 | Sum of Litres | Sum of Reserve % alcohol | Sum of Sugar | Sum of Amount
16041500 | MACKEREL | (blank) | CN | (blank) |  |  |  | 0 | 0 | 0 | 0 | 28.8
17049000 | SUGAR CONFECTIONARY | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 156.16
18061000 | CHOCOLATE PREPARATIONS | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 159.12
18063100 | CHOCOLATE | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 100.8
18063200 | CEREAL BAR CHOCOLATE | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 202.4
18063200 | CHOCOLATES | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 50.4
18069090 | CHOCOLATE CONFECTIONARY | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 33.6
19011000 | BABY MILK CEREALS | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 250.08
19012000 | DOUGHS | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 11.4
19019090 | CEREAL PREPARATIONS | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 100.28
19019090 | COCOA  POWDER BEVERAGES | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 29.52
19019090 | FOOD PREPARATIONS | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 29.16
19021990 | PASTA | (blank) | LT | (blank) |  |  |  | 0 | 0 | 0 | 0 | 15.84
19023000 | PASTA | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 102
19041000 | CEREAL PREPARATIONS | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 1016.08
19042000 | CEREAL PREPARATIONS | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 53.2
19042000 | MIXED CEREAL PREPAARTIONS | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 79.2
19042000 | MIXED CEREAL PREPARATIONS | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 892.62
19053100 | BISCUITS | (blank) | AE | (blank) |  |  |  | 0 | 0 | 0 | 0 | 14.4
19053100 | BISCUITS | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 646.8
19053100 | BISCUITS | (blank) | ES | (blank) |  |  |  | 0 | 0 | 0 | 0 | 54.2
19053100 | BISCUITS | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 33.12
19054090 | BREAD CRACKERS | (blank) | PL | (blank) |  |  |  | 0 | 0 | 0 | 0 | 30.24
19054090 | SLICED RUSKS | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 19.08
19059090 | BISCUITS | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 7.44
19059090 | CEREAL BAR HONEY | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 6.72
19059090 | CORN CAKES | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 27.84
19059090 | SNACK PREPARATIONS | (blank) | CN | (blank) |  |  |  | 0 | 0 | 0 | 0 | 168
20021000 | PRESERVED TOMATOES | (blank) | CN | (blank) |  |  |  | 0 | 0 | 0 | 0 | 105.84
20021000 | PRESERVED TOMATOES | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 17.28
20057000 | OLIVE PREPARATIONS | (blank) | ES | (blank) |  |  |  | 0 | 0 | 0 | 0 | 38.4
20081110 | PEANUT BUTTER | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 40.92
20087000 | PEACHES IN SYRUP | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 13.92
20093900 | LEMON JUICES | (blank) | ZA | 4*12*500ML | 24 | 720 | 0 | 48 | 24 | 0 | 720 | 36.96
21011100 | COFFEE | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 252.48
21021000 | YEASTS | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 86.4
21032000 | TOMATO SAUCE | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 405.9
21039010 | CHILLI SAUCES | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 69.12
21039090 | [NAME] | (blank) | IT | (blank) |  |  |  | 0 | 0 | 0 | 0 | 134.1
21039090 | [NAME] | (blank) | PL | (blank) |  |  |  | 0 | 0 | 0 | 0 | 20.68
21039090 | [NAME] | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 84.72
21039090 | SAUCES | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 156
21041000 | SOUPS PREPARATIONS | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 254.4
21069070 | JUICE CONCENTRATE | (blank) | ZA | 13*12*1L | 156 | 312 | 0 | 156 | 156 | 0 | 312 | 95.16
21069070 | JUICE CONCENTRATE | (blank) | ZA | 3*12*1L | 36 | 72 | 0 | 36 | 36 | 0 | 72 | 21.96
21069070 | JUICE CONCENTRATE | (blank) | ZA | 32*12*1L | 384 | 768 | 0 | 384 | 384 | 0 | 768 | 234.24
21069070 | JUICE CONCENTRATE | (blank) | ZA | 7*12*1L | 84 | 20.328 | 0 | 84 | 84 | 0 | 20.328 | 21
21069090 | DRINKING POWDERED PREPARATIONS | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 86.46000000000001
21069090 | PEANUT BUTTER CEREAL | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 42.8
21069090 | PEANUT CEREAL BAR | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 354
21069090 | SWEETENERS | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 78.72
22011021 | AERATED WATERS | (blank) | ZA | 10*12*1L | 120 | 456 | 0 | 120 | 120 | 0 | 456 | 49.2
22011021 | AERATED WATERS | (blank) | ZA | 16*12*1L | 192 | 729.5999999999999 | 0 | 192 | 192 | 0 | 729.5999999999999 | 78.72
22011021 | AERATED WATERS | (blank) | ZA | 18*12*1L | 216 | 820.8 | 0 | 216 | 216 | 0 | 820.8 | 88.56
22011021 | AERATED WATERS | (blank) | ZA | 18*12*500ML | 108 | 410.4 | 0 | 216 | 108 | 0 | 410.4 | 60.48
22011021 | AERATED WATERS | (blank) | ZA | 20*12*1L | 240 | 912 | 0 | 240 | 240 | 0 | 912 | 98.4
22011021 | AERATED WATERS | (blank) | ZA | 22*12*1L | 264 | 1003.2 | 0 | 264 | 264 | 0 | 1003.2 | 108.24
22011021 | AERATED WATERS | (blank) | ZA | 22*12*500ML | 132 | 501.6 | 0 | 264 | 132 | 0 | 501.6 | 73.92
22011021 | AERATED WATERS | (blank) | ZA | 25*12*500ML | 150 | 570 | 0 | 900 | 450 | 0 | 1710 | 252
22011021 | AERATED WATERS | (blank) | ZA | 26*12*500ML | 156 | 592.8 | 0 | 312 | 156 | 0 | 592.8 | 87.36
22011021 | AERATED WATERS | (blank) | ZA | 3*12*1L | 36 | 136.8 | 0 | 36 | 36 | 0 | 136.8 | 14.76
22011021 | AERATED WATERS | (blank) | ZA | 30*12*500ML | 180 | 684 | 0 | 360 | 180 | 0 | 684 | 75.6
22011021 | AERATED WATERS | (blank) | ZA | 34*12*500ML | 204 | 775.1999999999999 | 0 | 408 | 204 | 0 | 775.1999999999999 | 114.24
22011021 | AERATED WATERS | (blank) | ZA | 41*12*1L | 492 | 1869.6 | 0 | 492 | 492 | 0 | 1869.6 | 201.72
22011021 | AERATED WATERS | (blank) | ZA | 48*12*1L | 576 | 2188.8 | 0 | 576 | 576 | 0 | 2188.8 | 236.16
22011021 | AERATED WATERS | (blank) | ZA | 49*12*500ML | 294 | 1117.2 | 0 | 1176 | 588 | 0 | 2234.4 | 329.28
22011021 | AERATED WATERS | (blank) | ZA | 50*12*1L | 600 | 2280 | 0 | 600 | 600 | 0 | 2280 | 246
22011021 | AERATED WATERS | (blank) | ZA | 50*12*500ML | 300 | 1140 | 0 | 600 | 300 | 0 | 1140 | 126
22011021 | AERATED WATERS | (blank) | ZA | 50*12*500ML | 300 | 11400 | 0 | 600 | 300 | 0 | 11400 | 168
22021010 | ALOE VERA JUICE | (blank) | TW | 1*24*500ML | 12 | 72 | 0 | 24 | 12 | 0 | 72 | 11.28
22021010 | ALOE VERA JUICE | (blank) | TW | 3*12*1.5L | 54 | 334.8000000000001 | 0 | 36 | 54 | 0 | 334.8000000000001 | 36.36
22021010 | ALOE VERA JUICE | (blank) | TW | 3*24*500ML | 36 | 223.2 | 0 | 72 | 36 | 0 | 223.2 | 34.56
22021010 | ALOE VERA JUICE | (blank) | TW | 6*12*1.5L | 108 | 648 | 0 | 72 | 108 | 0 | 648 | 75.6
22021010 | ALOE VERA JUICE | (blank) | TW | 9*24*500ML | 108 | 648 | 0 | 216 | 108 | 0 | 648 | 105.84
22021010 | ENERGY DRINKS | [NAME] ([NAME]) | ZA | 1*24*500ML | 12 | 240 | 0 | 24 | 12 | 0 | 240 | 10.32
22021010 | ENERGY DRINKS | [NAME] ([NAME]) | ZA | 1*24*500ML | 12 | 1032 | 0 | 24 | 12 | 0 | 1032 | 10.32
22021010 | ENERGY DRINKS | [NAME] ([NAME]) | ZA | 2*24*500ML | 24 | 2064 | 0 | 48 | 24 | 0 | 2064 | 20.64
22021010 | ENERGY DRINKS | [NAME] ([NAME]) | ZA | 4*24*500ML | 48 | 4128 | 0 | 96 | 48 | 0 | 4128 | 41.28
22021010 | ENERGY DRINKS | (blank) | ZA | 3*24*300ML | 21.6 | 1857.6 | 0 | 72 | 21.6 | 0 | 1857.6 | 23.76
22021020 | CANNED  DRINKS | (blank) | ZA | 1*24*200ML | 4.800000000000001 | 9.360000000000003 | 0 | 24 | 4.800000000000001 | 0 | 9.360000000000003 | 5.28
22021020 | CANNED  DRINKS | (blank) | ZA | 5*24*330ML | 39.6 | 1486.8 | 0 | 120 | 39.6 | 0 | 1486.8 | 27.6
22029930 | FRUIT DRINKS | (blank) | ZA | 20*6*1.5L | 180 | 5760 | 0 | 240 | 360 | 0 | 11520 | 180
22029930 | FRUIT DRINKS | (blank) | ZA | 40*6*1.5L | 360 | 11520 | 0 | 240 | 360 | 0 | 11520 | 180
22042190 | WINES | (blank) | IT | 2*6*750ML | 9 |  |  | 12 | 9 | 0 | 0 | 22.56
25010019 | IODATED SALT | [NAME] (S000128) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 20
25010019 | SALT PREPARATION | [NAME] (S000128) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 35
33049900 | COSMETIC  PREPARATIONS | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 17.4
34011190 | SOAPS | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 36.72
34011900 | WIPES | (blank) | CN | (blank) |  |  |  | 0 | 0 | 0 | 0 | 127.2
34013000 | BODY WASH | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 30
34022090 | CLEANING PREPARATIONS | [NAME] (S000129) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 83.52
34022090 | CLEANING PREPARATIONS | [NAME] (S000131) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 539.1200000000001
34022090 | CLEANING PREPARATIONS | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 52.56
34022090 | CLEANING PREPARATIONS | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 245.89
34022090 | SOFTENER | [NAME] (S000129) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 16.08
34022090 | SOFTENER | [NAME] (S000131) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 144.72
34022090 | SOFTENER | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 150.6
39232990 | PACKINGS [NAME] | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 144
42029290 | [NAME] | (blank) | CN | (blank) |  |  |  | 0 | 0 | 0 | 0 | 65.28
56012190 | ARTICLES OF WADDING | (blank) | ZA | (blank) |  |  |  | 0 | 0 | 0 | 0 | 26.04
63026000 | TOILET LINEN | (blank) | PK | (blank) |  |  |  | 0 | 0 | 0 | 0 | 9.8
64022000 | SANDALS | (blank) | CN | (blank) |  |  |  | 0 | 0 | 0 | 0 | 95.76
64029900 | SANDALS | (blank) | CN | (blank) |  |  |  | 0 | 0 | 0 | 0 | 87
64029900 | SHOES | (blank) | CN | (blank) |  |  |  | 0 | 0 | 0 | 0 | 101.04
69111000 | TABLESWARES | (blank) | CN | (blank) |  |  |  | 0 | 0 | 0 | 0 | 3.72
69111000 | TABLEWARES | (blank) | CN | (blank) |  |  |  | 0 | 0 | 0 | 0 | 250.5
69120000 | CERAMIC TABLEWARES | (blank) | CN | (blank) |  |  |  | 0 | 0 | 0 | 0 | 142
94017900 | SEATS | (blank) | CN | (blank) | 0 |  |  | 96 | 0 | 0 | 0 | 501.12
94032090 | IRONING BOARD | (blank) | CN | (blank) | 0 |  |  | 6 | 0 | 0 | 0 | 42.18
94037090 | COOLER BOX | (blank) | ZA | (blank) | 0 |  |  | 8 | 0 | 0 | 0 | 61.04
96190019 | BABY DIAPERS | (blank) | ZA | (blank) | 0 |  |  | 150 | 0 | 0 | 0 | 780
96190040 | TAMPONS | (blank) | ZA | (blank) | 0 |  |  | 48 | 0 | 0 | 0 | 48.48
04090000 | HONEY | (blank) | ZA | (blank) | 0 |  |  | 144 | 0 | 0 | 0 | 406.08
08062000 | DRIED RAISINS | (blank) | ZA | (blank) | 0 |  |  | 200 | 0 | 0 | 0 | 222
09109910 | CURRY POWDER | (blank) | ZA | (blank) | 0 |  |  | 72 | 0 | 0 | 0 | 26.88
09109910 | CURRY POWDERS | (blank) | ZA | (blank) | 0 |  |  | 80 | 0 | 0 | 0 | 45.6
10063090 | [NAME] | (blank) | ZA | (blank) | 0 |  |  | 30 | 0 | 0 | 0 | 18.6
11010000 | FLOUR | [NAME] (S000130) | ZA | (blank) | 0 |  |  | 24 | 0 | 0 | 0 | 34.08
11031300 | MAIZE MEAL | (blank) | ZA | (blank) | 0 |  |  | 150 | 0 | 0 | 0 | 90
12129900 | DRINKING PLANT PREPARATIONS | (blank) | ZA | (blank) | 0 |  |  | 120 | 0 | 0 | 0 | 142.8
15091000 | OLIVE OILS | (blank) | ES | (blank) | 0 |  |  | 48 | 0 | 0 | 0 | 149.28
15179000 | COOKING SPRAY | (blank) | ZA | (blank) | 0 |  |  | 120 | 0 | 0 | 0 | 140.4
Grand Total |  |  |  |  |  |  |  | 10896 | 7047.000000000001 | 0 | 67521.288 | 15296.49