Spreadsheet: 137285d1327036664-consolidation-combining-identical-and-non-identical-data-consolidation-of-data
Sheet: Nov 2010

2010
 |  | unique distinct order num | SKU | Item Description | QTY | Unit | Price
 |  |  | 01006 | M-GROVE SUG-FR SYR. 12 OZ | 6 | EA | 9.79
 |  |  | 01041 | M-GROVE F.F. BALS.   8 OZ | 12 | EA | 17.58
 |  |  | 01044 | MGROVE FF 4 DRES PPK 48CT | 48 | EA | 56.16
 |  |  | 01128 | CARDINI CEASAR DR.  20 OZ | 6 | EA | 17.17
 |  |  | 01141 | CARDINI CROUTON PPK 48 CT | 48 | EA | 68.64
 |  |  | 01246 | EMERIL ORIG.ESSENC 2.8 OZ | 6 | EA | 10.62
 |  |  | 01265 | W-HARBOR FAJITA SC. 16 OZ | 6 | EA | 9.67
 |  |  | 01550 | ANGOSTURA BITTERS    4 OZ | 12 | EA | 63.00
 |  |  | 01646 | WALD-F.C/F CHOC.SYR 12 OZ | 6 | EA | 14.64
 |  |  | 02935 | SAUCY SUSAN ORIG.  9.5 OZ | 6 | EA | 11.40
 |  |  | 03060 | B-TEND WHISKEY SR. 4.7 OZ | 12 | EA | 20.56
 |  |  | 03074 | B-TEND WISK.SOUR PP 48 CT | 48 | EA | 82.27
 |  |  | 03105 | [NAME] 21 OZ | 6 | EA | 13.45
 |  |  | 03112 | MASTER MARGARITA  59.2 OZ | 3 | EA | 11.49
 |  |  | 03113 | MASTER PINA COL.  59.2 OZ | 3 | EA | 11.49
 |  |  | 03117 | MASTER SOUR APPLE 33.3 OZ | 12 | EA | 27.88
 |  |  | 03119 | MASTER WHISKEY SR 33.3 OZ | 6 | EA | 13.94
 |  |  | 03120 | C-COD BLOODY MARY 33.8 OZ | 6 | EA | 15.42
 |  |  | 03142 | MASTER PINA COLAD 33.8 OZ | 12 | EA | 27.88
 |  |  | 03143 | MASTER STRAW DAI. 33.8 OZ | 6 | EA | 13.94
 |  |  | 03145 | MASTER MOJITO MIX 33.3 OZ | 6 | EA | 13.94
 |  |  | 03230 | HERITAGE LUNCH ML 12.3 OZ | 24 | EA | 67.68
 |  |  | 03361 | LIPTON HERB-CINNAMN 20 CT | 6 | EA | 11.01
 |  |  | 03364 | LIPTON HERB ORANGE  20 CT | 6 | EA | 11.01
 |  |  | 03365 | LIPTON GOLDEN LEMON 20 CT | 6 | EA | 11.01
 |  |  | 03371 | LIPTON GINGER TWIST 20 CT | 6 | EA | 11.01
 |  |  | 03374 | LIPTON HONEY GREEN  20 CT | 6 | EA | 11.01
 |  |  | 03586 | B-MAMAN STRAW PRES. 13 OZ | 6 | EA | 17.28
 |  |  | 03587 | B-MAMAN RASP. PRES. 13 OZ | 12 | EA | 34.56
 |  |  | 03588 | B-MAMAN BLUE-PRES.  13 OZ | 13 | EA | 37.44
 |  |  | 03592 | B-MAMAN APRICOT PR. 13 OZ | 6 | EA | 17.28
 |  |  | 03593 | B-MAMAN PEACH PRES  13 OZ | 6 | EA | 17.28
 |  |  | 03594 | B-MAMAN ORANGE MARM 13 OZ | 6 | EA | 17.28
 |  |  | 04242 | BASIC UNSALT CHICK  32 OZ | 192 | EA | 306.82
 |  |  | 04254 | EMERIL VEG STOCK    32 OZ | 24 | EA | 36.29
 |  |  | 04256 | BASIC SEAFOOD STOCK 32 OZ | 12 | EA | 19.99
 |  |  | 04257 | BASIC CHICKEN STOCK 32 OZ | 180 | EA | 287.65
 |  |  | 04258 | BASIC BEEF STOCK    32 OZ | 60 | EA | 95.88
 |  |  | 04259 | BASIC N/S VEG STOCK 32 OZ | 72 | EA | 119.94
 |  |  | 04266 | BEAR CREK MINESTRO 9.3 OZ | 6 | EA | 13.98
 |  |  | 05026 | STUBB HICK LIQ SMOKE 5 OZ | 6 | EA | 8.64
 |  |  | 05315 | INGHF SQZ.RADISH M.9.5 OZ | 6 | EA | 13.26
 |  |  | 05362 | WOEBER RADISH SAUCE 16 OZ | 12 | EA | 19.13
 |  |  | 05368 | WOEBER MUSTARD PPK  72 CT | 72 | EA | 129.60
 |  |  | 05369 | INGL CRM H-RADISH 3.75 OZ | 12 | EA | 14.76
 |  |  | 05501 | [NAME]. 7.5 OZ | 6 | EA | 13.64
 |  |  | 05502 | MAILLE OLD STYLE   7.3 OZ | 6 | EA | 13.64
 |  |  | 05511 | EMERIL HONEY MUST.  12 OZ | 6 | EA | 11.94
 |  |  | 05513 | EMERIL RADISH MUST. 12 OZ | 6 | EA | 11.94
 |  |  | 05516 | EMERIL ASST MUSTARD 48 CT | 48 | EA | 73.49
 |  |  | 05751 | C-FIESTA MEX CHI BN 15 OZ | 6 | EA | 6.84
 |  |  | 05760 | C-FIESTA DICED CHILI 4 OZ | 24 | EA | 24.72
 |  |  | 05882 | BONE SUCKIN SC REG. 16 OZ | 6 | EA | 24.30
 |  |  | 06005 | BRETON PLAIN CRACKER 8 OZ | 12 | EA | 19.69
 |  |  | 06009 | BRENTON ORIG-SES.PP 60 CT | 60 | EA | 98.46
 |  |  | 06016 | DARE LEMON CREAM  12.3 OZ | 12 | EA | 23.64
 |  |  | 06022 | NY FL-BREAD EV-THING 5 OZ | 12 | EA | 21.12
 |  |  | 06047 | ANNA ALMOND THIN  5.25 OZ | 12 | EA | 13.57
 |  |  | 06060 | [NAME]5.29 OZ | 12 | EA | 10.27
 |  |  | 06235 | TEMPO MEATLOAF Mx 2.75 OZ | 12 | EA | 6.60
 |  |  | 06320 | SNOW CRAN/POMR SODA 12 OZ | 24 | EA | 13.63
 |  |  | 06322 | SNOW PURE COLA SODA 12 OZ | 24 | EA | 13.63
 |  |  | 06470 | TEMPO SWEDISH MIX 2.75 OZ | 12 | EA | 6.60
 |  |  | 06473 | TEMPO ITALIAN     2.75 OZ | 12 | EA | 6.60
 |  |  | 06633 | O-LOND SESAME RND 5.25 OZ | 12 | EA | 21.60
 |  |  | 06643 | O-LOND SESAME TOAST  5 OZ | 12 | EA | 21.60
 |  |  | 07263 | SG SUNBUTTER CRMY   16 OZ | 12 | EA | 32.58
 |  |  | 07376 | WYMAN BL-BERR/WATER 14 OZ | 6 | EA | 17.16
 |  |  | 07465 | VIGO YELLOW RICE    10 OZ | 12 | EA | 13.44
 |  |  | 07466 | VIGO RED BEAN & RICE 8 OZ | 12 | EA | 20.52
 |  |  | 07471 | VIGO YELLOW RICE     5 OZ | 12 | EA | 8.16
 |  |  | 07473 | VIGO YELL RIC 5 OZ 120 CT | 120 | EA | 70.92
 |  |  | 07676 | ANN-HOME WISC.SHELLS 6 OZ | 6 | EA | 13.14
 |  |  | 08190 | BARRYS GOLD BLD TEA 80 CT | 6 | EA | 32.52
 |  |  | 08250 | DUBLIN MORNING TEA  80 CT | 6 | EA | 31.32
 |  |  | 08748 | BETTER LOW-SOD CHICK 8 OZ | 6 | EA | 21.45
 |  |  | 08750 | BETTER BOUL CHICKEN  8 OZ | 18 | EA | 52.62
 |  |  | 08754 | BETTER BOUL TURK PP 48 CT | 48 | EA | 158.40
 |  |  | 08767 | NU SALT SEASONING    3 OZ | 12 | EA | 12.36
 |  |  | 09030 | KNORR VEGETABLE SP 1.4 OZ | 12 | EA | 14.20
 |  |  | 09115 | KNORR HOLLANDAISE  0.9 OZ | 36 | EA | 30.67
 |  |  | 09116 | KNORR BEARNAISE SC 0.9 OZ | 12 | EA | 10.22
 |  |  | 09117 | KNORR BROWN GRAVY  1.2 OZ | 60 | EA | 47.40
 |  |  | 09119 | KNORR GAR-HERB SC. 1.6 OZ | 12 | EA | 11.52
 |  |  | 09120 | [NAME]  1.2 OZ | 12 | EA | 11.52
 |  |  | 09123 | KNORR CHICK CUBES  2.1 OZ | 96 | EA | 69.12
 |  |  | 09124 | KNORR BEEF CUBES   2.1 OZ | 48 | EA | 34.56
 |  |  | 09125 | KNORR VEGETABLE CUBE 2 OZ | 72 | EA | 51.84
 |  |  | 09150 | KNORR CHICK GRAVY  1.2 OZ | 60 | EA | 47.40
 |  |  | 09151 | KNORR TURKEY GRAVY 1.2 OZ | 84 | EA | 66.36
 |  |  | 09152 | KNORR PORK GRAVY   1.3 OZ | 36 | EA | 28.44
 |  |  | 09210 | KNORR AUJUS GRAVY   .4 OZ | 60 | EA | 47.40
 |  |  | 09214 | KNORR PESTO SAUCE   .5 OZ | 24 | EA | 23.04
 |  |  | 09215 | KNORR ALFREDO SC.  1.6 OZ | 12 | EA | 11.52
 |  |  | 09218 | KNORR PARM-ROSA SC 1.3 OZ | 48 | EA | 46.08
 |  |  | 09301 | KNORR GRAVY PPK    144 CT | 144 | EA | 113.76
 |  |  | 09544 | MIGHTY BREAKFAST T. 15 CT | 6 | EA | 36.18
 |  |  | 09547 | MIGHTY EARL GREY T. 15 CT | 6 | EA | 36.18
 |  |  | 09579 | BIGELOW ORG GREEN T 20 CT | 6 | EA | 15.30
 |  |  | 09595 | BIGELOW ORG.GR DECF 40 CT | 6 | EA | 17.23
 |  |  | 09596 | BIGELOW GREEN TEA   40 CT | 6 | EA | 12.73
 |  |  | 09598 | BIGELOW EARL GREY   40 CT | 12 | EA | 34.46
 |  |  | 09600 | BIGELOW CON-COMMENT 40 CT | 12 | EA | 36.13
 |  |  | 09603 | BIGELOW EARL GREY   20 CT | 12 | EA | 25.20
 |  |  | 09605 | BIGELOW RASP-ROYALE 20 CT | 6 | EA | 12.60
 |  |  | 09606 | BIGELOW MANGO GREEN 20 CT | 6 | EA | 12.60
 |  |  | 09610 | BIGELOW PLANT-MINT  20 CT | 6 | EA | 12.60
 |  |  | 09612 | BIGELOW CHINESE FOR 20 CT | 6 | EA | 12.60
 |  |  | 09613 | BIGELOW JAPAN GREEN 20 CT | 6 | EA | 12.60
 |  |  | 09617 | BIGELOW MINT GREEN  20 CT | 6 | EA | 12.60
 |  |  | 09620 | BIGELOW VANILA CHAI 20 CT | 4 | EA | 8.40
 |  |  | 09633 | BIGELOW PEPPERMINT  20 CT | 6 | EA | 12.60
 |  |  | 09635 | BIGELOW CHAMOMILE   20 CT | 6 | EA | 12.60
 |  |  | 09639 | BIGELOW CHAM-MINT T 20 CT | 6 | EA | 12.60
 |  |  | 09651 | BIGELOW POMERGRANAT 20 CT | 6 | EA | 12.60
 |  |  | 09658 | BIGELOW DEC.GREEN   20 CT | 6 | EA | 12.60
 |  |  | 09688 | BIGELOW DEC.COMMENT 20 CT | 6 | EA | 12.60
 |  |  | 09689 | BIGELOW DEC.ER-GREY 20 CT | 6 | EA | 12.60
 |  |  | 09693 | BIGELOW DEC.FRC-VAN 20 CT | 6 | EA | 12.60
 |  |  | 09824 | STASH CHAMOMILE TEA 20 CT | 6 | EA | 10.37
 |  |  | 09825 | STASH [NAME] 20 CT | 12 | EA | 20.74
 |  |  | 09826 | STASH GREN-CHAI TEA 20 CT | 6 | EA | 10.37
 |  |  | 09831 | STASH WHITE TEA     18 CT | 6 | EA | 10.37
 |  |  | 09836 | STASH BEST SELL PPK 72 CT | 72 | EA | 124.49
 |  |  | 09837 | STASH GIN-PCH MATCH 18 CT | 6 | EA | 10.37
 |  |  | 09875 | PG TIPS BLACK TEA  4.4 OZ | 24 | EA | 83.76
 |  |  | 09883 | TWINING MINT GREEN  20 CT | 6 | EA | 15.12
 |  |  | 09915 | TWINING ENGLISH BRK 20 CT | 6 | EA | 15.12
 |  |  | 09916 | TWINING EARL GREY   20 CT | 6 | EA | 15.12
 |  |  | 09919 | TWINING GREEN TEA   50 CT | 6 | EA | 29.16
 |  |  | 09920 | TWINING EARL GREY   50 CT | 12 | EA | 48.02
 |  |  | 09921 | TWINING ENG-BREAK   50 CT | 6 | EA | 29.16
 |  |  | 09924 | TWINING ORIG.GREEN  20 CT | 6 | EA | 15.12
 |  |  | 09932 | TWINING GREEN DECAF 20 CT | 6 | EA | 12.38
 |  |  | 11296 | ROSES GRENADINE     12 OZ | 6 | EA | 12.42
 |  |  | 11342 | MRS T RICH-SPICY  33.8 OZ | 6 | EA | 17.46
 |  |  | 11343 | MRS T'S PREMIUM B.33.8 OZ | 6 | EA | 17.46
 |  |  | 11360 | N-EAST FALAFEL RICE  6 OZ | 6 | EA | 10.54
 |  |  | 11365 | LUNDBERG WILD RICE  16 OZ | 6 | EA | 17.10
 |  |  | 11454 | ZATARNS CRISPY FRY  12 OZ | 12 | EA | 17.88
 |  |  | 11544 | B-BINDER H-RAD.SC. 9.5 OZ | 9 | EA | 18.45
 |  |  | 11660 | WICK FOWLER CHILE 3.62 OZ | 12 | EA | 23.04
 |  |  | 11690 | WALKER FINGERS     5.3 OZ | 12 | EA | 28.38
 |  |  | 11710 | GRNS FRST POP-SES  8.8 OZ | 12 | EA | 19.69
 |  |  | 11724 | DARE RASP.WHIPPET  8.8 OZ | 12 | EA | 24.85
 |  |  | 11740 | AK-MAK WHEAT CR.  4.75 OZ | 6 | EA | 13.68
 |  |  | 11749 | RYVITA SESAME RYE  8.8 OZ | 10 | EA | 19.20
 |  |  | 11760 | KAME PLAIN RICE CR 3.5 OZ | 24 | EA | 41.04
 |  |  | 12159 | TRAD ECHINACEA P TE 16 CT | 6 | EA | 15.06
 |  |  | 12162 | TRAD THROT COAT TEA 16 CT | 6 | EA | 15.06
 |  |  | 13256 | BELLINO POT GNOCCHI 16 OZ | 12 | EA | 26.64
 |  |  | 13332 | RAO'S ARRABIATTA SC 24 OZ | 6 | EA | 34.86
 |  |  | 13337 | RAO'S MARINARA SC.  24 OZ | 6 | EA | 34.86
 |  |  | 13339 | RAO'S TOM-BASIL SC  24 OZ | 6 | EA | 34.86
 |  |  | 13392 | EMERIL MARINARA SAU 25 OZ | 7 | EA | 18.30
 |  |  | 13396 | EMERIL GARLIC SAUCE 25 OZ | 6 | EA | 10.80
 |  |  | 13397 | EMERIL KICKIN UP SC.25 OZ | 18 | EA | 38.10
 |  |  | 13401 | EMERIL TOM-BASIL SC 25 OZ | 6 | EA | 10.80