Spreadsheet: 150775d1334677181-concatenate-and-nested-if-statements-concatenate-and-if-statement
Sheet: Sheet1

 |  |  |  | Product Hierarchy | CAPT MORGAN RUM BLK SPICED 94P 1L (9144175)
 |  |  |  | Company Code | CT
 |  |  |  | Product Name | On Off Premise | Customer Name
 |  |  |  | CAPT MORGAN RUM BLK SPICED 94P 1L (9144175) | OFF PREMISE | ACHORN PACKAGE (700055603)
 |  |  |  |  |  | BUY-RITE LIQUOR (700056176)
 |  |  |  |  |  | CAMPBELL PACKAGE (700103057)
 |  |  |  |  |  | CENTER PACKAGE STORE (700056321)
 |  |  |  |  |  | COUNTRYSIDE WINE & SPIRI (700056607)
 |  |  |  |  |  | D & D LIQUORS (700056678)
 |  |  |  |  |  | HODGES SQUARE WINE/SPIRI (700057413)
 |  |  |  |  |  | MUT'S PACKAGE STORE (700078070)
 |  |  |  |  |  | ROGERS LAKE LIQUOR SHOPPE (700100819)
 |  |  |  |  |  | [NAME] (700077580)
 |  |  |  |  |  | STAR DISCOUNT LIQUOR (700059284)
 |  |  |  |  |  | TOWER LIQUORS (700059562)
 |  |  |  |  |  | TOWN & COUNTRY LIQUOR (700059567)
 |  |  |  |  |  | UNION LIQUORS (700059654)
 |  |  |  |  |  | WALSHS LIQUOR STORE (700059823)
 |  |  |  |  |  | WEST RIVER WINE & SPIRIT (700059868)
 |  |  |  |  | ON PREMISE | ABIS JAPANESE RESTAURANT (700079048)
 |  |  |  |  |  | AL'S COOKOUT (700070180)
 |  |  |  |  |  | AMERICAN LEGION #002 (700055663)
 |  |  |  |  |  | ANCIENT MARINER CAFE (700055720)
 |  |  |  |  |  | [NAME] (700055741)
 |  |  |  |  |  | [NAME] (700055744)
 |  |  |  |  |  | ANTONIO'S (700055750)
 |  |  |  |  |  | BAR NONE (700099571)
 |  |  |  |  |  | BARNUM PUBLICK HOUSE (700103059)
 |  |  |  |  |  | BRICKHOUSE (700056106)
 |  |  |  |  |  | BURGER BAR & BISTRO (700073544)
 |  |  |  |  |  | BUTTERFIELD 8 RESTAURANT & LOUNGE (700069674)
 |  |  |  |  |  | CASA BLANCA RESTAURANT (700100331)
 |  |  |  |  |  | CHENGDU RESTAURANT (700056369)
 |  |  |  |  |  | CLARION INN (700102526)
 |  |  |  |  |  | COPPERWOOD GRILL (700079798)
 |  |  |  |  |  | DEMIR'S RESTAURANT (700079430)
 |  |  |  |  |  | DOWNTOWN DANNY'O (700056796)
 |  |  |  |  |  | EXCHANGE BAR & GRILL (700070622)
 |  |  |  |  |  | FAST EDDIE'S BILLIARD CAFE (700079805)
 |  |  |  |  |  | FIREHOUSE BAR & GRILL (700070032)
 |  |  |  |  |  | FREE SPIRIT CAFE (700057111)
 |  |  |  |  |  | HORSESHOE RESTAURANT (700057456)
 |  |  |  |  |  | HUGO'S RESTAURANT INC (700057476)
 |  |  |  |  |  | ISCHODA YACHT CLUB (700057539)
 |  |  |  |  |  | [NAME] (700057614)
 |  |  |  |  |  | JOHNNY'S GRILL (700057640)
 |  |  |  |  |  | KAZIMIR PULASKI CLUB (700057696)
 |  |  |  |  |  | [NAME] (700057716)
 |  |  |  |  |  | LAUREL ATHLETIC CL (700057820)
 |  |  |  |  |  | [NAME] HEAD INN (700057844)
 |  |  |  |  |  | [NAME] (700058063)
 |  |  |  |  |  | MILL ON THE RIVER (700058186)
 |  |  |  |  |  | MONSTER B'S BAR & GRILLE (700058223)
 |  |  |  |  |  | O'BRIENS SPORTS PUB & REST (700057770)
 |  |  |  |  |  | OLD CORNER CAFE (700070834)
 |  |  |  |  |  | OYSTER RIVER TAVERN (700058502)
 |  |  |  |  |  | PARTNERS CAFE (700058563)
 |  |  |  |  |  | PEARL LOUNGE (700079102)
 |  |  |  |  |  | PIGS EYE PUB (700058629)
 |  |  |  |  |  | POLISH [NAME] (700058694)
 |  |  |  |  |  | PRESPA RESTAURANT (700058751)
 |  |  |  |  |  | REYES BAR & REST (700058855)
 |  |  |  |  |  | [NAME] REST (700059134)
 |  |  |  |  |  | SOLE CAFE & LOUNGE (700100277)
 |  |  |  |  |  | SOUTH NORWALK BOAT CLUB (700059203)
 |  |  |  |  |  | SPORTSMAN CAFE (700059252)
 |  |  |  |  |  | SYMMETRY (700079305)
 |  |  |  |  |  | THE HOOK (700102842)
 |  |  |  |  |  | THE HUB BAR & GRILLE (700059475)
 |  |  |  |  |  | THE SHACK (700055895)
 |  |  |  |  |  | TIERNAN'S PUB & REST (700059511)
 |  |  |  |  |  | TIGIN IRISH PUB (700059515)
 |  |  |  |  |  | TOLL GATE TAVERN (700102934)
 |  |  |  |  |  | TUCKERS CAFE (700059611)
 |  |  |  |  |  | TUMBLE BROOK C.C. (700059613)
 |  |  |  |  |  | UNCLE [NAME]. (700059650)
 |  |  |  |  |  | VITO'S BY THE WATER (700059802)
 |  |  |  |  |  | WAMPANOAG COUNTRY CLU (700059825)
 |  |  |  |  |  | WATERBURY COUNTRY CLB (700059842)
 |  |  |  |  |  | WEE BURN COUNTRY CLUB (700059856)
 |  |  |  |  |  | WESTSIDE BAR & GRILL / NIGHT OWL (700070192)
 |  |  |  |  |  | [NAME] (700097045)
 |  |  |  |  |  | ZEN BAR (700061357)
 |  |  |  |  |  | [NAME] (700056792)