Spreadsheet: 98643d1297503787-excel-2007-pivot-table-location-wise
Sheet: Sheet2

 |  |  |  |  |  |  |  | I DON’T WANT THE BLANK ROWS I NEED PIVOT TABLE TO SHOW ME ONLY THOSE LINE WHICH HAVE THE QUANTITY
ITEM | P01
0600X16  USA CHKN TYSON | (blank)
0700X10  BR CHKN GOLENPHOENIX | (blank)
[NAME] CHKN PENA BRANCA | (blank)
0700X10  BR CHKN SANTA/SEARA | (blank)
0800X10  BR CHKN GOLDEN DOUX | (blank)
0800X10  BR CHKN NAT. | (blank)
0800X10  BR CHKN PENA BRNCA | 1
0800X10  BRZ CHKN FRANGOSUL | (blank)
0900X10  BR CHKN GOLDEN DOUX | (blank)
0900X10  BR CHKN NAT. | 2
0900X10  BR CHKN PENA BRANCA | (blank)
0900X10  BR CHKN SANTA/SEARA | (blank)
0950X10 FU CHKN FARUJ DHAID | (blank)
10 KG  BR CHKN Q.LEGS FRANGO  BOM | 15096
10 KG  USA CHKN Q.LEGS  TYSON | (blank)
10.80KG  BR CHKN WINGS SEARA | (blank)
1000X10  ARG CHKN SIERRASUR | (blank)
1000X10  BR CHKN G.PHOENIX | (blank)
1000X10  BR CHKN GOLDEN DOUX | (blank)
1000X10  BR CHKN NAT. | (blank)
1000X10  BR CHKN PENA BRNCA | 40
1000X10  BR CHKN SANTA/SEARA | (blank)
1000X10  BR CHKN SUANGO | 4
1000X10  BR CHKN UNEF | (blank)
1000X10  BR CHKN ZEINA | (blank)
1000X10  USA CHKN TYSON | (blank)
1000X10 ARG CHKN TYSON | (blank)
1000X10 BR CHKN ALLIZ | (blank)
1000X10 BR CHKN AVERAMA | (blank)
1000X10 FU CHKN FARUJ DHAID | (blank)
1000X12  DA CHKN PADBORG | (blank)
1050X10 FU CHKN FARUJ DHAID | (blank)
10KG BL WHOLE CHKN BRZ BORELLA | (blank)
10X01 KG  FR FRIES BELG GEKO | (blank)
10X01 KG  FR FRITS DUTCH NOWACO | (blank)
10X01KG  VEG SPINACH CHI | (blank)
10X900GM  BR DSTICK  NAT | 889
10X900GM BR CHKN THIGH NAT | (blank)
1100X10  ARG CHKN BECAR | (blank)
1100X10  ARG CHKN SOYCHU | (blank)
1100X10  ARG CHKN TYSON | (blank)
1100X10  BR CHKN AURORA | (blank)
1100X10  BR CHKN BONDIO | (blank)
1100X10  BR CHKN G.PHONIEX | (blank)
1100X10  BR CHKN GOLDEN DOUX | (blank)
1100X10  BR CHKN NAT. | (blank)
1100X10  BR CHKN PENA BRANCA | 2
1100X10  BR CHKN SANTA/SEARA | 1
1100X10  BR CHKN SUANGO | (blank)
1100X10  BR CHKN UNEF | (blank)
1100X10 FU CHKN FARUJ DHAID | (blank)
1100X10 KSA CHKN ALISLAMI | (blank)
1100X12  DA CHKN PADBORG | (blank)
1150X10 FU CHKN FARUJ DHAID | (blank)
12 KG BR CHKN BREAST NAT. | (blank)
1200X10  ARG CHKN BECAR | (blank)
1200X10  ARG CHKN SIERRASUR | (blank)
1200X10  ARG CHKN TYSON | (blank)
1200X10  BR CHKN BONDIO | (blank)
1200X10  BR CHKN G.PHOENIX | (blank)
1200X10  BR CHKN GOLDEN DOUX | (blank)
1200X10  BR CHKN NAT. | (blank)
1200X10  BR CHKN PENA BRNCA | 2
1200X10  BR CHKN SANTA/SEARA | 1
1200X10  BR CHKN SUANGO | (blank)
1200X10  BR CHKN UNEF | (blank)
1200X10  BRZ CHKN AVERAMA | (blank)
1200X10  DA CHKN PADBORG | (blank)
1200X10 FU CHKN FARUJ DHAID | (blank)
1200X10 KSA CHKN ALISLAMI | (blank)
1250X10 FU CHKN FARUJ DHAID | (blank)
12X01 VINELEAVES GLASS JAR EGE YLDIZI | (blank)
12X1LTR LEMON JUICE EGE YLDIZI | (blank)
12X900GM  BR CDSTICK BIG  AVERAMA | (blank)
12X900GM  BR CHKN BREST NAT | (blank)
12X900GM  BR DSTICK BIG CANCAO | (blank)
12X900GM  BR DSTICK BIG LANGUIRU | (blank)
12X900GM  BR DSTICK BIG PENA | 2602
12X900GM  BR DSTICK BIG-FIT | (blank)
12X900GM  BR DSTICK BIG-TYSON | 1081
12X900GM  BR DSTICK SML-NICOLINI | (blank)
13.6KG  FR FRITS USA 6X2.27K | (blank)
1300X10  ARG CHKN TYSON | (blank)
1300X10  BR CHKN AVIPAL | (blank)
1300X10  BR CHKN BONDIO | (blank)
1300X10  BR CHKN G.PHONEIX | (blank)
1300X10  BR CHKN GOLDEN DOUX | (blank)
1300X10  BR CHKN NAT. | 419
1300X10  BR CHKN PENA BRNCA | 522
1300X10  BR CHKN SANTA/SEARA | 3811
1300X10  BRZ CHKN AVERAMA | (blank)
1300X10  DA CHKN PADBORG | (blank)
1300X10 ARG CHKN BECAR | (blank)
1300X10 BR CHKN SUANGO | (blank)
1300X10 FU CHKN FARUJ DHAID | (blank)
1350X10 FU CHKN FARUJ DHAID | (blank)
13KG SHEEP LIVER COLES AUST | (blank)
1400X10  ARG CHKN BECAR | (blank)
1400X10  ARG CHKN SIERRASUR | (blank)
1400X10  ARG CHKN TYSON | (blank)
1400X10  BR CHKN BONIDO | (blank)
1400X10  BR CHKN G.PHOENIX | (blank)
1400X10  BR CHKN GOLDEN DOUX | (blank)
1400X10  BR CHKN NAT. | (blank)
1400X10  BR CHKN PENA BRNCA | (blank)
1400X10  BR CHKN SANTA/SEARA | (blank)
1400X10  BR CHKN UNEF | (blank)
1400X10  DA CHKN PADBORG | (blank)
1400X10 ARG CHKN SOYUCHU | (blank)
1400X10 BR CHKN SUANGO | (blank)
1400X10 FU CHKN FARUJ DHAID | (blank)
1450X10 FU CHKN FARUJ DHAID | (blank)
15 KG  BR CHKN Q.LEGS SANTA | (blank)
15 KG  BR CHKN Q.LEGS TYSON | 1099
15 KG  BR CHKN WING BONDIO | (blank)
15 KG  BR CHKN WING PENA BRANCA | 552
15 KG  BR CHKN WINGS FRIATO | (blank)
15 KG  US CHKN Q.LEGS  MOUNT.FARMS | 1849
15 KG  US CHKN Q.LEGS AJC | (blank)
15 KG  US CHKN Q.LEGS KEYFARMS | (blank)
15 KG  US CHKN Q.LEGS PILGRIM | (blank)
15 KG  US CHKN Q.LEGS TYSON | 3204
15 KG BR CHKN WINGS LP-NAT | (blank)
15 KG BR CHKN WINGS TYSON | (blank)
15 KG US B/S WHOLE LEGS TYSON | (blank)
1500X08  BR CHKN BORELLA | (blank)
1500X08  BR CHKN SANTA/SEARA | (blank)
1500X10  ARG CHKN BECAR | (blank)
1500X10  ARG CHKN TYSON | (blank)
1500X10  BR CHKN G.PHOENIX | (blank)
1500X10  BR CHKN GOLDEN DOUX | (blank)
1500X10  BR CHKN NAT. | (blank)
1500X10  BR CHKN PENA BRANCA | (blank)
1500X10  DA CHKN PADBORG | (blank)
1500X10 ARG CHKN SIERRASUR | (blank)
1500X10 BR CHKN BONDIO | (blank)
1500X10 BR CHKN SUANGO | (blank)
1500X10 FU CHKN FARUJ DHAID | (blank)
15KG BRZ CHKN WINGS COSSISA | 1630
15KG US CHKN DSTICK B/L S/L TYSON | 1350
1600X08  BR CHKN SANTA | (blank)
1600X10  BR CHKN PENA BRANCA | (blank)
1600X10  BR CHKN WESTFALIA | (blank)
1600X10  DN CHKN PADBORG | 1737.1
1600X10 ARG CHKN BECAR | (blank)
16KG  GUAVA PULP INDIAN | (blank)
16KG  MANGO PULP INDIAN | (blank)
1700X10  BR CHKN WESTFALIA | (blank)
1700X10  DN CHKN PADBORG | 2024
1700X10 ARG CHKN BECAR | (blank)
18 KG  BEEF MINCE ALAHMED | 756
18 KG  BEEF TLOIN ALLANA | (blank)
18 KG  BEEF TLOIN ALSAAD | (blank)
18 KG  BF CUBE  INDIAN EATCO | (blank)
18 KG  BF CUBE 5 STAR | (blank)
18 KG  BF CUBE AL-AFIA | (blank)
18 KG  BF CUBE GOLDEN STAR | (blank)
18 KG  BF MINCE 5 STAR | (blank)
18 KG  BF MINCE AL-AFIA | (blank)
18 KG  BF MINCE ALLANA | (blank)
18 KG  BF TLOIN AL-AFIA | (blank)
18 KG  BOBY VEAL 5STAR | 100
18 KG  BOBY VEAL AL-AFIA | 446
18 KG  BOBY VEAL ALLANA | (blank)
18 KG  BOBY VEAL ALQURESH | (blank)
18 KG  BOBY VEAL IND AMBER | (blank)
18 KG  BOBY VEAL MUMTZ/NAFE | (blank)
18 KG  BOBY VEAL PREMIER | (blank)
18 KG  BOBY VEAL REEM | 1072
18 KG  MTTN CUBE FIVE STAR | (blank)
18 KG  MTTN CUBE IND EATCO | (blank)
18 KG  VEAL CUBES [NAME] | (blank)
18 KG  VEAL CUBES KAMIL | (blank)
18 KG  VEAL LEG AL-FIZA | (blank)
18 KG  VEAL LEGS AL ARABI | (blank)
18 KG  VEAL LEGS ALLANA | (blank)
18 KG  VEAL ROLL AMBER IND | (blank)
18 KG  VEAL TLOIN AL-LAIBA | (blank)
18 KG  VEAL TLOIN ALMAJED/AL-FIZA | (blank)
18 KG  VEAL TLOIN REEM | (blank)
18 KG  VTLOIN IND AMBER | 178
18 KG BEEF [NAME] | (blank)
18 KG BEEF TOPSIDE AL-AFIA | (blank)
18 KG BOBY VEAL ALFIZA | (blank)
18 KG VEAL CUBES AL-AFIA | (blank)
18 KG VEAL CUBES AL-LAHAM | (blank)
18 KG VEAL CUBES ALMUNTAHA | (blank)
18 KG VEAL CUBES PRIMO | (blank)
18 KG VEAL LEGS AL-AFIA | (blank)
18 KG VEAL LEGS MUSA | (blank)
1800X08  BR CHKN WESTFALIA | (blank)
1800X09 DN CHKN PADBORG | 1196
1800X10 ARG CHKN BECAR | (blank)
18KG  VEAL TLOIN AL-AFIA | 2
18KG BEEF CUBES AL-FIZA | (blank)
18KG BEEF CUBES INDIAN AMBER | (blank)
1900X08  BR CHKN WESTFALIA | (blank)
1900X09 DN CHKN PADBORG | 760
1KGX17 WHITE AKAWI CHEESE STAR LOK | (blank)
1X17.5KG BR CHKN MDM SEARA | 5087
20 KG  BEEF TLOIN 5 STAR | (blank)
20 KG  BEEF TLOIN AMBER | (blank)
20 KG  BEEF TLOIN IND REEM | (blank)
20 KG  BEEF TRIMMING INDIAN ALAFIA | (blank)
20 KG  BF TLOIN AL NOOR | (blank)
20 KG  BF TOPSIDE ALLANA | (blank)
20 KG  BF TOPSIDE ALNAFEES | (blank)
20 KG  BF TOPSIDE REEM | (blank)
20 KG  VEAL LEG AL AHMED | (blank)
20 KG  VEAL LEG FIVE STAR | (blank)
20 KG  VEAL LEGS AL LAHAM | (blank)
20 KG  VEAL LEGS ALM | (blank)
20 KG  VEAL LEGS ALTAJ | (blank)
20 KG  VEAL LEGS AMBER IND | 1
20 KG  VEAL LEGS MUMTAZ NAFE | (blank)
20 KG  VEAL LEGS REEM | 607
20 KG  VEAL TLOIN ALM | (blank)
20 KG  VEAL TLOIN FIVE STAR | (blank)
20 KG  VEAL TLOIN REEM | (blank)
20 KG BEEF TENDERLOIN ALFIZA | (blank)
20 KG BF TOPSIDE ( 5 STAR) | (blank)
2000X08  BR CHKN WESTFALIA | (blank)
2000X08  DA CHKN PADBORG | 548
20X400 GM OKHRA EXTRA SIZE 0-2 | (blank)
20X400 GM OKHRA EXTRA-SIZE2-3 | (blank)
20X400GM  BEEF MINCE VENICIA | (blank)
20X400GM  BROAD BEANS MISR | (blank)
20X400GM  CUT GR.BEANS MISR/VANA | (blank)
20X400GM  GR PEAS CHINA  D&Z | (blank)
20X400GM  GR PEAS CHINA DYSP | (blank)
20X400GM  MIX VEG CHINA [NAME] | 574
20X400GM  MIX VEGATABLE  CHINA  D&Z | (blank)
20X400GM  MIX VEGETABLE EGYPT VANA | (blank)
20X400GM  MULUKHYA MISR | (blank)
20X400GM  OKHRA MISR | (blank)
20X400GM  STRAWBERRY MISR | (blank)
20X400GM  VEG GR PEAS MISR/VANA | (blank)
20X400GM  VEG OKHRA ONE MISR | (blank)
20X400GM CHOPPED SPINACH VANA | (blank)
20X400GM OKHRA MIXED | (blank)
20X400GM STRAWBERRY CHINA | (blank)
20X400GM STRAWBERRY VANA  EGYPT | (blank)
20X400GMS  SPINACH MISR | (blank)
20X450 GM  BR CHKN GIZARD AVERAMA | (blank)
20X450 GM  BR CHKN GIZARD CONCAO | 4388
20X450 GM  BR CHKN GIZARD NAT. | 310
20X450 GM  BR CHKN LIVER AVERMA | (blank)
20X450 GM  BR CHKN LIVER AVIPAL | (blank)
20X450 GM  BR CHKN LIVER CANCO | 2197
20X450 GM  BR CHKN LIVER NAT | 3248
20X450 GM  BR CHKN LIVER ZEINA | (blank)
20X500ML LEMON JUICE EGE YLDIZI | (blank)
24X340 GM  BR CHKN FRANK AURORA | 3958
24X340 GM  BR CHKN FRANK COPACOL | (blank)
24X340 GM  BR CHKN FRANK G.PHEONIX | 6616
24X340 GM  BR CHKN FRANK ROYAL | (blank)
24X450 GM  BR CHKN GIZARD PENABRCA | (blank)
24X450 GM  BR CHKN LIVER BONDIO | (blank)
25X400GM  VEG BROAD BEANS | (blank)
25X400GM  VEG MULUKHYA VANA/MISR | (blank)
30X500GM BR CHKN LIVER JAGUA | (blank)
40X250GM TUR CHEESE HALOOUMI GRN ISLAND | (blank)
4X2.5 KG  BR BL CHKN AVIPAL | (blank)
4X2.5 KG  BR BL CHKN BONDIO | (blank)
4X2.5 KG  BR BL CHKN BORELA/UNF | (blank)
4X2.5 KG  BR BL CHKN CANCAO | (blank)
4X2.5 KG  BR BL CHKN DIPLOMAT | (blank)
4X2.5 KG  BR BL CHKN GLOBOAVES | (blank)
4X2.5 KG  BR BL CHKN NAT | (blank)
4X2.5 KG  BR BL CHKN PENA BRANCA | (blank)
4X2.5 KG  BR BL CHKN SEARA | (blank)
4X2.5 KG  BR BL CHKN VALUESUL | (blank)
4X2.5 KG  BR CHKN BREST SANTA | (blank)
4X2.5 KG  BR CHKN BREST TYSON | (blank)
4X2.5 KG  CUT GREEN BEAN TOMEX | (blank)
4X2.5 KG  FR FRIES [NAME] | (blank)
4X2.5 KG  FR FRIES DUTCH NOWACO | (blank)
4X2.5 KG  FR FRITS  TOMEX | (blank)
4X2.5 KG  FR FRITS MISR | (blank)
4X2.5 KG  GR PEAS CHINA DYSP | 1200
4X2.5 KG  MIX VEG CHINA [NAME] | 500
4X2.5 KG FR FRITES BELG GEKO | (blank)
4X2.5KG BR BL S/ON CHICKEN FRIATO | (blank)
4X2.5KG FRENCH FRITES EARLY DAWN | 3940
4X2.5KG GREEN PEAS CHINA  D&Z | (blank)
4X2.5KG GREEN PEAS TOMEX | (blank)
4X2.5KG SPINACH TOMEX | (blank)
4X2.75KG AKBEL TURKISH LEBNEH | (blank)
4X4 KG  NAZ CHKN WINGS | (blank)
4X5KG VINELEAVES  EGE YLDIZI | (blank)
6X2.0 KG  BR BL CHKN DIPLOMAT | (blank)
6X2.0 KG  BR BL CHKN PENABRNCA | (blank)
6X2.0 KG  BR CHKN BREAST COPAGRIL | (blank)
6X2.0 KG  BR CHKN BREAST TYSON | 4876
6X2.0 KG  BR CHKN BREST  DA-GRANJA | 2206
6X2.0 KG  BR CHKN BREST  TRAMONTO | (blank)
6X2.0 KG  BR CHKN BREST AURORA | 2249
6X2.0 KG  BR CHKN BREST DIPLOMAT | (blank)
6X2.0 KG  BR CHKN BREST S/ON AL-SAFA | (blank)
6X2KG  BR CHKN BREST CANCAO | (blank)
6X2KG BR CHKN BL SL LEGS CANCAO | (blank)
6X2KG BR CHKN LEG BONELESS SEARA | (blank)
8X2 KG  DNK CHKN WINGS 16KG | (blank)
BEEF EYEROUND MINERVA | (blank)
BEEF FORQUARTER BRAZIL TATUIBI | (blank)
BEEF HINDQUARTER BRAZIL MARFIG | (blank)
BEEF KNUCKLE ARGENTINA | (blank)
BEEF SILVERSIDE ARGENTINA | (blank)
BEEF SILVERSIDE BRZ FRIBOI | (blank)
BEEF [NAME] | (blank)
BEEF STRIPLOIN MINERVA | (blank)
BEEF TENDERLOIN BRAZIL FRIBOI | (blank)
BEEF TENDERLOIN BRAZIL MINERVA | (blank)
BEEF TOPSIDE ARGENTINA | (blank)
BEEF TOPSIDE MINERVA | (blank)
BOBY VEAL 6WAY CUTS AUST CEDAR | (blank)
CHKN BURGER ALKABEER 10KG | (blank)
ELBOW W/GROOVES-20X500G-ARBELLA | (blank)
ELBOW W/OUT GROVS-20X500G-ARBELLA | (blank)
FUSILI ROTANI-20X500G-ARBELLA | (blank)
G LIVER AUST BURRANGONG | (blank)
HOGGET CARCASES U/17KG | (blank)
LAMB B/N RACK / FLANK URUGUAY | (blank)
LAMB B/N SHOULDER URUGAY | (blank)
LAMB CCS AUST  180 | (blank)
LAMB CCS AUST 156 BURRANGONG | (blank)
LAMB CCS AUST 246 | (blank)
LAMB CCS AUST 3085 | (blank)
LAMB CCS AUST EST.612 | (blank)
LAMB CCS AUST M.C HERD | (blank)
LAMB CCS AUST WAMCO EST.572 | (blank)
LAMB CCS AUSTRALIAN 206 | 396
LAMB CCS INDIAN AL FIZA | (blank)
LAMB CCS INDIAN ALLANA | (blank)
LAMB CCS INDIAN ALNAFEES/MUMTAZ | (blank)
LAMB CCS INDIAN ALTAMAM | (blank)
LAMB CCS INDIAN FIVESTAR | (blank)
LAMB CCS NZ YL | (blank)
LAMB CCS NZ YM | (blank)
LAMB CCS NZ YX | (blank)
LAMB CCS URUGUAY | (blank)
LAMB FORE NZ AFFCO | 735
LAMB FORES NZ ALLIANCE | 2252
LAMB LEG B/N URUGUAY | (blank)
LAMB LIVER AUSTRALIAN | (blank)
LAMB SHOULDER SQ-CUT AUST | (blank)
[NAME] COSSISA | 2273
MTTN CARCASS AUSTRIALIA | (blank)
MTTN LEGS BN AUST | (blank)
MTTN LEGS BN NZ | (blank)
MTTN RACKS BONE IN AUST | (blank)
MTTN SIX WAY CUT AUST -ARARAT | (blank)
MTTN SIX WAY CUT AUST -M.C.HERD | 1178
MUTTON LEG B/IN-ARARAT | (blank)
MUTTON LEG B/N AUST- VICTORIA | (blank)
PENNE RIGATE-20X500G-ARBELLA | (blank)
[NAME] | (blank)
SPAGHETTI-1.3MM-20X500G-ARBELLA | (blank)
SPAGHETTI-1.5MM-20X500G-ARBELLA | (blank)
[NAME] CREAM BUTTER U/S-25KG-PARAS | (blank)
VEAL CARCASS 6W/CUT-TASMAN | (blank)
VEAL CARCASS 6WAY CUT TASMAN | (blank)
WHOLE MILK POWDER INSTANT - PARAS | (blank)
Grand Total