Spreadsheet: 856405d1705658270-2-spreadsheets-different-rows-duplicate-data-lookup-help-needed-trying-to-work-out-rayteds-requirements-aligw
Sheet: Sheet1

 |  | ORIGINAL DATA |  |  |  |  |  |  | UNIQUE ROWS
 | 30 | MCGGN ES AUS RS OTH11.5%18.75C | '[PHONE] | Mcguigan Estate Rose Wine 11.5% 187ml [NAME] Bottle Australia | Still [NAME] |  |  |  | MCGGN ES AUS RS OTH11.5%18.75C | '[PHONE] | Mcguigan Estate Rose Wine 11.5% 187ml [NAME] Bottle Australia | Still [NAME]
 | 32 | CSLR D DBL DC O.S WT CHL12%75C | '[PHONE] | Casillero Del Diablo Devils Collection Brut Chardonnay 12% 75cl [NAME] Chile | Total Other Sparkling Wine |  |  | 32 | CSLR D DBL DC O.S WT CHL12%75C | '[PHONE] | Casillero Del Diablo Devils Collection Brut Chardonnay 12% 75cl [NAME] Chile | Total Other Sparkling Wine
 | 35 | KLEIN ST SA RD MERLOT 13% 75CL | '[PHONE] | [NAME] 13% Red Wine 75cl  [NAME] | Still Red Wine |  |  | 35 | KLEIN ST SA RD MERLOT 13% 75CL | '[PHONE] | [NAME] 13% Red Wine 75cl  [NAME] | Still Red Wine
 | 178 | KRNBG 1664 P.LG CN 5%  4X440ML |  |  | Premium Lager |  |  | 178 | KRNBG 1664 P.LG CN 5%  4X440ML |  |  | Premium Lager
 | 216 | RED STRP P.LGR CN 4.7%   440ML |  |  | World Beer |  |  | 216 | RED STRP P.LGR CN 4.7%   440ML |  |  | World Beer
 | 302 | C.D.O SPN RD OT      13.5%75CL | '[PHONE] | Castillo De Olite Tinto Navarra Red Wine 13.5% Spain Glass Bottle 75cl | Still Red Wine |  |  | 302 | C.D.O SPN RD OT      13.5%75CL | '[PHONE] | Castillo De Olite Tinto Navarra Red Wine 13.5% Spain Glass Bottle 75cl | Still Red Wine
 | 357 | GLMRGN WLSH CK STT BT4.5%500ML | '[PHONE] | [NAME] 4.5% 500ml Glass Bottle | Stouts & Porters |  |  | 357 | GLMRGN WLSH CK STT BT4.5%500ML | '[PHONE] | [NAME] 4.5% 500ml Glass Bottle | Stouts & Porters
 | 358 | B.D HOP RCKR P.LG CN 5.2%660ML | '[PHONE] | [NAME] India Pale Lager 5.2% Glass Bottle 660ml | Craft Beer |  |  | 358 | B.D HOP RCKR P.LG CN 5.2%660ML | '[PHONE] | [NAME] India Pale Lager 5.2% Glass Bottle 660ml | Craft Beer
 | 360 | PERRYS VINTAGE BTL 7.2%  500ML | '[PHONE] | Perrys Somerset Cider Vintage 7.2% Glass Bottle 500ml | Apple Cider |  |  | 360 | PERRYS VINTAGE BTL 7.2%  500ML | '[PHONE] | Perrys Somerset Cider Vintage 7.2% Glass Bottle 500ml | Apple Cider
 | 364 | BIRRA MRTI G/AN P.LG BT8%750ML | '[PHONE] | [NAME] Antichi 8% Premium Lager Glass Bottle 750ml | World Beer |  |  | 364 | BIRRA MRTI G/AN P.LG BT8%750ML | '[PHONE] | [NAME] Antichi 8% Premium Lager Glass Bottle 750ml | World Beer
 | 476 | TRS CLST SPNSH OTHR RD 14%75CL | '[PHONE] | Torres Celeste Crianza Red Wine Spain 14% Glass Bottle 75cl | Still Red Wine |  |  | 476 | TRS CLST SPNSH OTHR RD 14%75CL | '[PHONE] | Torres Celeste Crianza Red Wine Spain 14% Glass Bottle 75cl | Still Red Wine
 | 496 | WSTNS OLD RSE SCRMP 6.8%BT500M | '[PHONE] | Westons Old Rosie The Original Cloudy Cider 6.8% Glass Bottle 500ml | Apple Cider |  |  | 496 | WSTNS OLD RSE SCRMP 6.8%BT500M | '[PHONE] | Westons Old Rosie The Original Cloudy Cider 6.8% Glass Bottle 500ml | Apple Cider
 | 499 | SNS SPNSH RED RIOJA  13.5%75CL | '00335331 | Canto Sainsburys By [NAME] Tempranillo Garnacha Spain Red Wine Glass Bottle 13.5% 75cl | Still Red Wine |  |  | 499 | SNS SPNSH RED RIOJA  13.5%75CL | '00335331 | Canto Sainsburys By [NAME] Tempranillo Garnacha Spain Red Wine Glass Bottle 13.5% 75cl | Still Red Wine
 | 513 | HRDYS BIN AUST WH SVN BL13%75C | '[PHONE] | Hardys Bin 161 Sauvignon Blanc White Wine 13% 75cl [NAME] Bottle Australia | Still White Wine |  |  | 513 | HRDYS BIN AUST WH SVN BL13%75C | '[PHONE] | Hardys Bin 161 Sauvignon Blanc White Wine 13% 75cl [NAME] Bottle Australia | Still White Wine
 | 513 | HRDYS BIN AUST WH SVN BL13%75C | '[PHONE] | Hardys Bin 161 Sauvignon Blanc Australia 13% 75cl White Wine Glass Bottle | Still White Wine |  |  | 513 | HRDYS BIN AUST WH SVN BL13%75C | '[PHONE] | Hardys Bin 161 Sauvignon Blanc Australia 13% 75cl White Wine Glass Bottle | Still White Wine
 | 533 | HEINEKEN/S S.LGR BT 4% 4X330ML | '[PHONE] | Heineken Silver Pure Malt Lager 4% 4x330ml [NAME] | Premium Lager |  |  | 533 | HEINEKEN/S S.LGR BT 4% 4X330ML | '[PHONE] | Heineken Silver Pure Malt Lager 4% 4x330ml [NAME] | Premium Lager
 | 546 | BAILEYS ETON MESS 17%     70CL | '[PHONE] | [NAME] Liqueur 17% 70cl Glass Bottle | Cream Liqueurs |  |  | 546 | BAILEYS ETON MESS 17%     70CL | '[PHONE] | [NAME] Liqueur 17% 70cl Glass Bottle | Cream Liqueurs
 | 597 | SAINT ETIENNE P.LG C4.6% 440ML |  |  | Value Beer |  |  | 597 | SAINT ETIENNE P.LG C4.6% 440ML |  |  | Value Beer
 | 598 | [NAME] C4.6%4X440M |  |  | Value Beer |  |  | 598 | [NAME] C4.6%4X440M |  |  | Value Beer
 | 631 | HEINEKEN/S S.LGR CN 4% 6X330ML | '[PHONE] | Heineken Silver Pure Malt Lager 6x330ml Cans | Premium Lager |  |  | 631 | HEINEKEN/S S.LGR CN 4% 6X330ML | '[PHONE] | Heineken Silver Pure Malt Lager 6x330ml Cans | Premium Lager
 | 779 | VK BLACK CHERRY BTL 4%   700ML | '[PHONE] | Vk Black Cherry 4% Spirit Based Drink 70cl Glass Bottle | Traditional RTD |  |  | 779 | VK BLACK CHERRY BTL 4%   700ML | '[PHONE] | Vk Black Cherry 4% Spirit Based Drink 70cl Glass Bottle | Traditional RTD
 | 779 | VK BLACK CHERRY BTL 4%   700ML | '[PHONE] | Vk Black Cherry Spirit Based Drink 4% 70cl Glass Bottle Pmp £2.79 | Traditional RTD |  |  | 779 | VK BLACK CHERRY BTL 4%   700ML | '[PHONE] | Vk Black Cherry Spirit Based Drink 4% 70cl Glass Bottle Pmp £2.79 | Traditional RTD
 | 779 | VK BLACK CHERRY BTL 4%   700ML | '[PHONE] | Vk Black Cherry W Alcohol & Fruit Juice [Sparkling W Sug & Sweetenr] Glbt 70cl 4% Uk Pm 2.99 | Traditional RTD |  |  | 779 | VK BLACK CHERRY BTL 4%   700ML | '[PHONE] | Vk Black Cherry W Alcohol & Fruit Juice [Sparkling W Sug & Sweetenr] Glbt 70cl 4% Uk Pm 2.99 | Traditional RTD
 | 795 | PERONI LGR 0.0% BTL   12X330ML | '[PHONE] | Peroni Nastro Azzurro Alcohol Free Lager 0.0% 12x330ml Glass Bottles | Low & No Alc Beer |  |  | 795 | PERONI LGR 0.0% BTL   12X330ML | '[PHONE] | Peroni Nastro Azzurro Alcohol Free Lager 0.0% 12x330ml Glass Bottles | Low & No Alc Beer
 | 795 | PERONI LGR 0.0% BTL   12X330ML | '[PHONE] | Peroni Nastro Azzurro 0.0% Non Alcoholic Italian Lager 12 X 330ml Glass Bottle | Low & No Alc Beer |  |  | 795 | PERONI LGR 0.0% BTL   12X330ML | '[PHONE] | Peroni Nastro Azzurro 0.0% Non Alcoholic Italian Lager 12 X 330ml Glass Bottle | Low & No Alc Beer
 | 30 | MCGGN ES AUS RS OTH11.5%18.75C | '[PHONE] | Mcguigan Estate Rose Wine 11.5% 187ml [NAME] Bottle Australia | Still [NAME] |  |  | 887 | CSTLDMNR OR SP RD TMPR13.5%75C | '[PHONE] | Castillo De Menara Organic Tempranillo Gran Seleccion 13.5% Red Wine 75cl [NAME] Bottle Spain | Still Red Wine
 | 32 | CSLR D DBL DC O.S WT CHL12%75C | '[PHONE] | Casillero Del Diablo Devils Collection Brut Chardonnay 12% 75cl [NAME] Chile | Total Other Sparkling Wine |  |  | 922 | SPR BCK BT 4.7%          660ML | '[PHONE] | Super Bock Beer, 4.7%, [NAME], 660ml | Premium Ale
 | 35 | KLEIN ST SA RD MERLOT 13% 75CL | '[PHONE] | [NAME] 13% Red Wine 75cl  [NAME] | Still Red Wine
 | 178 | KRNBG 1664 P.LG CN 5%  4X440ML |  |  | Premium Lager
 | 216 | RED STRP P.LGR CN 4.7%   440ML |  |  | World Beer
 | 302 | C.D.O SPN RD OT      13.5%75CL | '[PHONE] | Castillo De Olite Tinto Navarra Red Wine 13.5% Spain Glass Bottle 75cl | Still Red Wine
 | 357 | GLMRGN WLSH CK STT BT4.5%500ML | '[PHONE] | [NAME] 4.5% 500ml Glass Bottle | Stouts & Porters
 | 358 | B.D HOP RCKR P.LG CN 5.2%660ML | '[PHONE] | [NAME] India Pale Lager 5.2% Glass Bottle 660ml | Craft Beer
 | 360 | PERRYS VINTAGE BTL 7.2%  500ML | '[PHONE] | Perrys Somerset Cider Vintage 7.2% Glass Bottle 500ml | Apple Cider
 | 364 | BIRRA MRTI G/AN P.LG BT8%750ML | '[PHONE] | [NAME] Antichi 8% Premium Lager Glass Bottle 750ml | World Beer
 | 476 | TRS CLST SPNSH OTHR RD 14%75CL | '[PHONE] | Torres Celeste Crianza Red Wine Spain 14% Glass Bottle 75cl | Still Red Wine
 | 496 | WSTNS OLD RSE SCRMP 6.8%BT500M | '[PHONE] | Westons Old Rosie The Original Cloudy Cider 6.8% Glass Bottle 500ml | Apple Cider
 | 499 | SNS SPNSH RED RIOJA  13.5%75CL | '00335331 | Canto Sainsburys By [NAME] Tempranillo Garnacha Spain Red Wine Glass Bottle 13.5% 75cl | Still Red Wine
 | 513 | HRDYS BIN AUST WH SVN BL13%75C | '[PHONE] | Hardys Bin 161 Sauvignon Blanc White Wine 13% 75cl [NAME] Bottle Australia | Still White Wine
 | 513 | HRDYS BIN AUST WH SVN BL13%75C | '[PHONE] | Hardys Bin 161 Sauvignon Blanc Australia 13% 75cl White Wine Glass Bottle | Still White Wine
 | 533 | HEINEKEN/S S.LGR BT 4% 4X330ML | '[PHONE] | Heineken Silver Pure Malt Lager 4% 4x330ml [NAME] | Premium Lager
 | 546 | BAILEYS ETON MESS 17%     70CL | '[PHONE] | [NAME] Liqueur 17% 70cl Glass Bottle | Cream Liqueurs
 | 597 | SAINT ETIENNE P.LG C4.6% 440ML |  |  | Value Beer
 | 598 | [NAME] C4.6%4X440M |  |  | Value Beer
 | 631 | HEINEKEN/S S.LGR CN 4% 6X330ML | '[PHONE] | Heineken Silver Pure Malt Lager 6x330ml Cans | Premium Lager
 | 779 | VK BLACK CHERRY BTL 4%   700ML | '[PHONE] | Vk Black Cherry 4% Spirit Based Drink 70cl Glass Bottle | Traditional RTD
 | 779 | VK BLACK CHERRY BTL 4%   700ML | '[PHONE] | Vk Black Cherry Spirit Based Drink 4% 70cl Glass Bottle Pmp £2.79 | Traditional RTD
 | 779 | VK BLACK CHERRY BTL 4%   700ML | '[PHONE] | Vk Black Cherry W Alcohol & Fruit Juice [Sparkling W Sug & Sweetenr] Glbt 70cl 4% Uk Pm 2.99 | Traditional RTD
 | 887 | CSTLDMNR OR SP RD TMPR13.5%75C | '[PHONE] | Castillo De Menara Organic Tempranillo Gran Seleccion 13.5% Red Wine 75cl [NAME] Bottle Spain | Still Red Wine
 | 922 | SPR BCK BT 4.7%          660ML | '[PHONE] | Super Bock Beer, 4.7%, [NAME], 660ml | Premium Ale