Spreadsheet: 767592d1644533510-find-duplicate-columns-and-combine-data-excel-help
Sheet: formula

Site # | Site | City | Address | Postal Code | Province | Region | [NAME] | Planogram |  | ETH_SNACKS_08X84_ECONO_ATLANTIC_WHOLESALE | ETH_SNACKS_08X78_WEST_WHOLESALE | ETH_SNACKS_08X84_ECONO_WEST_WHOLESALE | KOSHER_ALL_IN_ONE_NON_VISUAL_67_FORTINOS | KOSHER_ALL_IN_ONE_NON_VISUAL_52_FORTINOS | ETH_SNACKS_06X84_ECONO_ONTARIO_WHOLESALE | [NAME] | ETH_CONFECTIONARY_SOUTH_ASIAN_04X24X24_DISCOUNT_EAST_NEW | ETH_CONFECTIONARY_SOUTH_ASIAN_04X12X24_ECONO_DISCOUNT_EAST | ETH_SNACKS_04X78_MARKET_QUEBEC | ETH_EAST_ASIAN_SNACKS_0XXXX_ECONO_QUEBEC | ETH_EAST_ASIAN_SNACKS_0XXXX_EXTRAFOODS | [NAME] | ETH_EAST_ASIAN_SNACKS_0XXXX_MARKET_WEST | ETH_EAST_ASIAN_SNACKS_0XXXX_MARKET_QUEBEC | ETH_CONFECTIONARY_SOUTH_ASIAN_0XXXXXXX_DISCOUNT_WEST_NEW | ETH_CONFECTIONARY_SOUTH_ASIAN_0XXXXXXX_DISCOUNT_EAST_NEW | ETH_CONFECTIONARY_MIDDLE_EAST_0XXXXXXX_ECONO_WEST_NOFRILLS_NEW | ETH_CONFECTIONARY_MIDDLE_EAST_0XXXXXXX_DISCOUNT_WEST_NEW | ETH_MIDDLE_EAST_XXXXX_ECONO_QUEBEC | ETH_MIDDLE_EAST_0XXXXXXX_FORTINOS | ETH_SOUTH_ASIAN_SNACKS_0XXXX_FORTINOS | ETH_SNACKS_SOUTH_ASIAN_0XXXXXXX_ECONO_EAST_NOFRILLS_NEW | ETH_SNACKS_SOUTH_ASIAN_0XXXXXXX_ECONO_WEST_NOFRILLS_NEW | ETH_SPREADS_SOUTH_ASIAN_0XXXXXXX_DISCOUNT_WEST_NEW | ETH_SPREADS_SOUTH_ASIAN_0XXXXXXX_DISCOUNT_EAST_NEW | ETH_SPREADS_SOUTH_ASIAN_0XXXXXXX_ECONO_EAST_NOFRILLS | ETH_SPREADS_SOUTH_ASIAN_0XXXXXXX_ECONO_WEST_NOFRILLS | ETH_SPREADS_SOUTH_ASIAN_0XXXXXXX_ECONO_EAST_NOFRILLS_NEW | ETH_SPREADS_SOUTH_ASIAN_0XXXXXXX_ECONO_WEST_NOFRILLS_NEW | ETH_SPREADS_SOUTH_ASIAN_0XXXXXXX_ECONO_DISCOUNT_EAST_NEW | ETH_CONFECTIONARY_SOUTH_ASIAN_0XXXXXXX_MARKET_EAST_NEW | ETH_CONFECTIONARY_MIDDLE_EAST_0XXXXXXX_MARKET_EAST_NEW | ETH_CANNED_FRUIT_FILIPINO_0XXXXXXX_DISCOUNT_WEST | ETH_CANNED_FRUIT_FILIPINO_0XXXXXXX_ECONO_EAST_NOFRILLS | ETH_CANNED_FRUIT_FILIPINO_0XXXXXXX_ECONO_DISCOUNT_EAST | ETH_CANNED_FRUIT_FILIPINO_0XXXXXXX_DISCOUNT_EAST | ETH_CANNED_FRUIT_FILIPINO_0XXXXXXX_ECONO_WEST_NOFRILLS | ETH_CANNED_FRUIT_FILIPINO_0XXXXXXX_ECONO_WEST_NOFRILLS_PILOT | ETH_SNACKS_SOUTH_ASIAN_XXXXXXXX_DISCOUNT_WEST_NEW | ETH_SNACKS_SOUTH_ASIAN_0XXXXXXX_DISCOUNT_WEST_NEW | ETH_SNACKS_SOUTH_ASIAN_XXXXXXXX_DISCOUNT_EAST_NEW | ETH_SNACKS_SOUTH_ASIAN_0XXXXXXX_ECONO_DISCOUNT_EAST_NEW | ETH_SNACKS_SOUTH_ASIAN_0XXXXXXX_DISCOUNT_EAST_NEW | ETH_SOUTH_ASIAN_COOKIES_0XXXX_FORTINOS | ETH_SOUTH_ASIAN_ALL_IN_ONE_XXXXX_MARKET_WEST | KOSHER_CANNED_0XXXX_MARKET_QUEBEC_SPECIALTY | KOSHER_CANNED_XXXXX_ONTARIO_SPECIALTY | KOSHER_CANNED_XXXXXXXX_ONTARIO_SPECIALTY | RTE_DESSERTS_0XXXXXX0_ECONO_ATLANTIC_WHOLESALE | RTE_DESSERTS_XXXXXXX0_ECONO_WEST_WHOLESALE | RTE_DESSERTS_0XXXXXX0_ECONO_WEST_WHOLESALE | RTE_DESSERTS_0XXXXXX0_ECONO_ONTARIO_WHOLESALE | RTE_DESSERTS_XXXXXXX0_WEST_WHOLESALE | RTE_DESSERTS_0XXXXXX0_QUEBEC_WHOLESALE | RTE_DESSERTS_0XXXXXX0_ECONO_QUEBEC_WHOLESALE | RTE_DESSERTS_0XXXXXX0_WEST_WHOLESALE | ETH_CONFECTIONARY_EAST_ASIAN_0XXXXXXX_DISCOUNT_WEST | ETH_CONFECTIONARY_EAST_ASIAN_0XXXXXXX_ECONO_EAST_NOFRILLS_NEW | ETH_CONFECTIONARY_EAST_ASIAN_0XXXXXXX_DISCOUNT_EAST | [NAME] | ETH_CONFECTIONARY_EAST_ASIAN_0XXXXXXX_ECONO_DISCOUNT_EAST_NEW | ETH_CONFECTIONARY_EAST_ASIAN_0XXXXXXX_ECONO_WEST_NOFRILLS_NEW | ETH_CONFECTIONARY_EAST_ASIAN_0XXXXXXX_ECONO_EAST_NOFRILLS | ETH_CONFECTIONARY_EAST_ASIAN_0XXXXXXX_ECONO_DISCOUNT_EAST | ETH_SOUTH_ASIAN_COOKIES_XXXXX_FORTINOS | ETH_SNACKS_SOUTH_ASIAN_XXXXXXXX_ECONO_EAST_NOFRILLS_NEW | ETH_SNACKS_SOUTH_ASIAN_XXXXXXXX_ECONO_WEST_NOFRILLS_NEW | ETH_SNACKS_SOUTH_ASIAN_XXXXXXXX_ECONO_EAST_NOFRILLS | ETH_SOUTH_ASIAN_SNACKS_XXXXX_FORTINOS | ETH_SNACKS_FILIPINO_0XXXXXXX_WEST_NOFRILLS_PILOT | ETH_SNACKS_FILIPINO_0XXXXXXX_DISCOUNT_WEST | ETH_SNACKS_FILIPINO_0XXXXXXX_ECONO_WEST_NOFRILLS | ETH_SNACKS_FILIPINO_XXXXXXXX_DISCOUNT_WEST | ETH_SNACKS_FILIPINO_0XXXXXXX_ECONO_DISCOUNT_EAST | ETH_SNACKS_FILIPINO_0XXXXXXX_DISCOUNT_EAST | ETH_SNACKS_FILIPINO_0XXXXXXX_ECONO_EAST_NOFRILLS | ETH_SNACKS_SOUTH_ASIAN_0XXXXXX0_MARKET_WEST_NEW | ETH_SNACKS_SOUTH_ASIAN_0XXXXXXX_MARKET_EAST_NEW | ETH_SPREADS_MIDDLE_EAST_0XXXXXXX_MARKET_EAST_NEW | ETH_CONFECTIONARY_BRITISH_0XXXXXXX_MARKET_EAST_NEW | DRY_DESSERT_0XXXX_ECONO_QUEBEC | [NAME] | DRY_DESSERT_0XXXXXX0_ECONO_ONTARIO_NOFRILLS_ETHNIC | DRY_DESSERT_0XXXX_ECONO_WEST_NOFRILLS | DRY_DESSERT_0XXXX_ECONO_ONTARIO_NOFRILLS | DRY_DESSERT_0XXXXXX0_ECONO_ONTARIO_NOFRILLS | DRY_DESSERT_0XXXX_ECONO_ATLANTIC_NOFRILLS | [NAME] | DRY_DESSERT_0XXXX_ONTARIO_NOFRILLS | DRY_DESSERT_0XXXXXXX_ECONO_ONTARIO_NOFRILLS | DRY_DESSERT_0XXXXXXX_ONTARIO_NOFRILLS_URBAN | DRY_DESSERT_0XXXX_EXTRAFOODS | DRY_DESSERT_XXXXX_EXTRAFOODS | DRY_DESSERT_XXXXX_ECONO_QUEBEC | DRY_DESSERT_0XXXX_DISCOUNT_ONTARIO | DRY_DESSERT_X0XXX_DISCOUNT_WEST | DRY_DESSERT_XXXXX_DISCOUNT_WEST | DRY_DESSERT_XXXXXXXX_XXBASEDECK_DISCOUNT_WEST | DRY_DESSERT_0XXXX_DISCOUNT_WEST | DRY_DESSERT_XXXXX_DISCOUNT_ONTARIO | ETH_CONFECTIONARY_EAST_ASIAN_0XXXXXXX_MARKET_EAST_NEW | ETH_CONFECTIONARY_EAST_ASIAN_0XXXXXX0_MARKET_WEST_NEW | ETH_BRITISH_0XXXXXXX_FORTINOS | ETH_BRITISH_XXXXXXXX_FORTINOS | ETH_CONFECTIONARY_MIDDLE_EAST_0XXXXXXX_ECONO_DISCOUNT_EAST_NEW | ETH_CONFECTIONARY_MIDDLE_EAST_0XXXXXXX_ECONO_EAST_NOFRILLS_NEW | ETH_CONFECTIONARY_MIDDLE_EAST_0XXXXXXX_DISCOUNT_EAST_NEW | ETH_SNACKS_FILIPINO_0XXXXXXX_MARKET_WEST | ETH_SNACKS_FILIPINO_0XXXXXXX_MARKET_EAST | ETH_SNACKS_FILIPINO_0XXXXXX0_MARKET_WEST | ETH_EAST_ASIAN_SNACKS_0XXXXXXX_FORTINOS | ETH_CONFECTIONARY_MIDDLE_EAST_0XXXXXXX_ECONO_EAST_NOFRILLS | [NAME] | DRY_DESSERT_0XXXXXX0_PUSHERS_FORTINOS_PILOT | DRY_DESSERT_0XXXXXXX_PUSHERS_FORTINOS_PILOT | RTE_DESSERTS_0XXXXXX0_ECONO_ONTARIO_WHOLESALE_FOODSERVICE | DRY_DESSERT_XXXXX_ONTARIO | DRY_DESSERT_0XXXX_ONTARIO | DRY_DESSERT_0XXXX_LOBLAWS_X0X0 | DRY_DESSERT_0XXXX_MARKET_WEST | [NAME] | DRY_DESSERT_XXXXX_ATLANTIC | DRY_DESSERT_0XXXXXX0_MARKET_QUEBEC | DRY_DESSERT_0XXXX_PROV | DRY_DESSERT_0XXXX_ATLANTIC_YIG | DRY_DESSERT_0XXXX_QUEBEC_CITYMARKET | DRY_DESSERT_XXXXX_PROV | DRY_DESSERT_XXXXX_BASKETS_ATLANTIC | DRY_DESSERT_0XXXX_ATLANTIC | DRY_DESSERT_0XXXX_BASKETS_ATLANTIC | DRY_DESSERT_0XXXX_ONTARIO_CITYMARKET | RTE_DESSERTS_0XXXXXXX_ECONO_WEST_NOFRILLS | RTE_DESSERTS_XXXXXXXX_ECONO_ATLANTIC_NOFRILLS | RTE_DESSERTS_X0XXXXXX_ECONO_QUEBEC | RTE_DESSERTS_XXXXXXXX_ECONO_QUEBEC | RTE_DESSERTS_XXXXXXXX_DISCOUNT_WEST | RTE_DESSERTS_XXXXXXXX_DISCOUNT_ONTARIO | RTE_DESSERTS_0XXXXXXX_ECONO_ONTARIO_NOFRILLS | RTE_DESSERTS_XXXXXXX0_ECONO_ONTARIO_NOFRILLS | RTE_DESSERTS_X0XXXXXX_DISCOUNT_ONTARIO | RTE_DESSERTS_0XXXXXXX_ECONO_ATLANTIC_NOFRILLS | [NAME] | [NAME] | RTE_DESSERTS_XXXXXXXX_ECONO_ONTARIO_NOFRILLS | RTE_DESSERTS_XXXXXXXX_EXTRAFOODS | [NAME] | RTE_DESSERTS_X0XXXXX0_ECONO_ONTARIO_NOFRILLS_ALLSTARS | RTE_DESSERTS_0XXXXXXX_ECONO_QUEBEC | RTE_DESSERTS_X0XXXXXX_ECONO_ATLANTIC_NOFRILLS | RTE_DESSERTS_X0XXXXXX_DISCOUNT_WEST | RTE_DESSERTS_0XXXXXXX_EXTRAFOODS | RTE_DESSERTS_XXXXXXXX_ECONO_WEST_NOFRILLS | RTE_DESSERTS_X0XXXXX0_ECONO_ONTARIO_NOFRILLS | RTE_DESSERTS_XXXXXXX0_ECONO_ONTARIO_NOFRILLS_ALLSTARS | RTE_DESSERTS_0XXXXXXX_ONTARIO_NOFRILLS_URBAN | RTE_DESSERTS_XXXXXXXX_ECONO_XFTBREAKOUT_ONTARIO_NOFRILLS | RTE_DESSERTS_X0XXXXXX_ECONO_XFTBREAKOUT_QUEBEC | RTE_DESSERTS_0XXXXXXX_XFTBREAKOUT_ECONO_WEST_NOFRILLS | RTE_DESSERTS_XXXXXXXX_FORTINOS | RTE_DESSERTS_XXXXXXX0_FORTINOS | [NAME] | RTE_DESSERTS_0XXXXXX0_FORTINOS_PILOT | RTE_DESSERTS_XXXXXXX0_MARKET_WEST | RTE_DESSERTS_0XXXXXX0_PROVF | RTE_DESSERTS_XXXXXXX0_PROVF | RTE_DESSERTS_XXXXXXXX_MARKET_QUEBEC | RTE_DESSERTS_0XXXXXX0_VALUMART | RTE_DESSERTS_X0XXXXXX_MARKET_ATLANTIC | RTE_DESSERTS_0XXXXXX0_ATLANTIC_YIG | RTE_DESSERTS_XXXXXXXX_MARKET_ATLANTIC | RTE_DESSERTS_X0XXXXXX_MARKET_ONTARIO | RTE_DESSERTS_0XXXXXXX_MARKET_ATLANTIC | RTE_DESSERTS_0XXXXXX0_WEST_CITYMARKET | RTE_DESSERTS_0XXXXXXX_MARKET_QUEBEC | RTE_DESSERTS_0XXXXXX0_MARKET_WEST | RTE_DESSERTS_0XXXXXXX_ONTARIO_CITYMARKET | RTE_DESSERTS_0XXXXXXX_MARKET_ONTARIO | RTE_DESSERTS_0XXXXXX0_QUEBEC_CITYMARKET | RTE_DESSERTS_0XXXXXX0_ONTARIO_CITYMARKET | [NAME] | RTE_DESSERTS_0XXXXXXX_MARKET_ONTARIO_X0X0 | RTE_DESSERTS_XXXXXXXX_ECONO_XFTBREAKOUT_QUEBEC | DRY_DESSERT_0XXXX_MARKET_QUEBEC_PROVIGOPLUS | RTE_DESSERTS_XXXXXXXX_XFTBREAKOUT_ECONO_QUEBEC
39 | Fort Brampton Mountainash
46 | Fort Stoney Creek Upper Centen
48 | Fort Hamilton Mall
55 | Fort Hwy 27
65 | Fort [NAME] James
67 | Fort [NAME]
78 | Fort Burlington Plains
86 | Fort Ancaster Wilson
96 | [NAME]
199 | Fort [NAME]
202 | WC [NAME]
209 | [NAME]
210 | [NAME]
211 | [NAME]
212 | [NAME]
214 | WC Kingston
215 | WC Lindsay
217 | [NAME]
220 | WC [NAME]
226 | WC Sudbury
231 | WC Owen Sounds
238 | WC Pembroke
244 | WC London
245 | WC Gloucester
248 | WC [NAME]
249 | [NAME]
254 | WC Brantford
262 | Agostino & Nancy's NF Oshawa
266 | Masse's NF London
268 | Mike & Lori's NF North Bay
273 | [NAME]' NF Etobicoke
277 | [NAME]'s NF Beamsville
289 | Dino's NF Toronto
291 | [NAME]'s NF Cobourg
293 | Grant's NF Kingston
300 | Fort Hamilton Centennial Pky
301 | [NAME]
307 | WC Halifax
309 | Atl SS Antigonish Market
311 | [NAME] [NAME]
312 | Atl SS Amherst Albion
313 | Atl SS Upper Tantallon
314 | Atl SS Summerside Granville
315 | [NAME]
316 | Atl SS Tracadie Principale
317 | Atl SS Port Hawkesbury Paint
318 | Atl SS [NAME]
321 | Atl SS North Sydney King
325 | Atl SS Edmundston Victoria
326 | Atl SS Moncton Trinity
329 | Atl SS Fredericton Main
331 | Atl SS [NAME]
332 | Atl SS Miramichi King George
336 | Atl SS Truro Elm
337 | Atl SS [NAME]
339 | Atl SS Digby Warwick
341 | Atl SS Fredericton Smythe
344 | Atl SS New Minas Commercial
347 | [NAME]
350 | Atl SS [NAME]
351 | Atl SS Lower Sackville
352 | Atl SS Dartmouth Portland
353 | [NAME] [NAME]
354 | Atl SS Halifax Young
357 | Atl SS Bathurst St Peter
358 | Atl SS Halifax Chain Lake
359 | Atl SS [NAME]
361 | Atl SS Riverview Coverdale
362 | Atl SS [NAME]
364 | Atl SS [NAME]
366 | [NAME]
367 | Atl SS Porters [NAME]
368 | Atl SS New Glasgow Westville
369 | Atl SS Halifax Barrington
372 | Atl SS [NAME]
373 | Atl SS Sydney Kings
374 | Atl SS [NAME]
375 | Atl SS Elmsdale Hwy 214
376 | Atl SS Charlottetown 465 Univ
377 | Atl SS Windsor Cole
378 | Atl SS [NAME]
379 | Atl SS Halifax [NAME]
380 | Atl SS Dartmouth Braemar
383 | Atl SS Halifax Quinpool
384 | [NAME] [NAME]
385 | [NAME]
386 | Atl SS Charlottetown 680 Univ
388 | Atl SS Montague Main
389 | Atl SS Sussex Lower Cove
396 | Atl SS Grand Falls Madawaska
405 | [NAME]' YIG Stittsville
408 | Baxtrom's YIG Cornwall
413 | [NAME]'s VM Chapleau
417 | [NAME]'s VM North York
421 | Barnabe's YIG Perth
440 | [NAME]'s VM Lindsay
444 | [NAME]'s YIG Pickering
450 | Wilson's YIG Ottawa
456 | Tetreault's VM Belle River
458 | [NAME]'s YIG Lively
467 | Dessureault YIG Orleans
476 | Grants YIG Hanover