Spreadsheet: 171927d1343916559-how-to-match-two-columns-of-data-in-excel-with-different-column-lengths-local-international-test-book
Sheet: Before

 |  | AN Plant | Supplier Physical Country | [NAME] (if applicable) |  | [NAME] (if applicable)
 |  | US | Australia | Friesland Joint Venture |  | (blank)
 |  | US | Australia | [NAME] |  | 21st Century Grain
 |  | US | Austria | Agrana Starke GmBH |  | Abitech
 |  | US | Austria | Jungbunzlauer Austria AG |  | ADM
 |  | US | Belgium | BENEO-Remy Industries |  | Advanced Ingredients
 |  | US | Brazil | Ajinomoto |  | Agropur
 |  | US | Canada | Archer Daniels Midland Company |  | Ajinomoto
 |  | US | Canada | Bioriginal |  | Amalgamated
 |  | US | Canada | Bunge |  | American Blanching
 |  | US | Canada | Casco |  | Ashta Chemicals
 |  | US | Canada | Innophos Pt. [NAME] |  | Autocrat
 |  | US | Canada | Jungbunzlauer |  | Azar Nut
 |  | US | Canada | Ocean Nutrition |  | Balchem
 |  | US | Canada | Sensient Pharmaceutical Technologies |  | BASF
 |  | US | China | APAC Chemical |  | Bell
 |  | US | China | Fuchi |  | [NAME]
 |  | US | China | Jiangyin TSI Pharmaceutical |  | [NAME]
 |  | US | China | Kaiyuan Hengtai Chemical Co Ltd |  | [NAME]
 |  | US | China | Ningbo Daxie Development Zone Haide Amino Acid Ind. Co., Ltd. |  | [NAME] and [NAME]
 |  | US | China | Prev: Jiangsu Jiangshan Pharmaceutical Co., Ltd |  | Bioriginal
 |  | US | China | [NAME] |  | Blommer
 |  | US | China | Wuxi Jinghai Amino Acid Co |  | BMI
 |  | US | China | Zhangjiagang Huachang Pharmaceutical Co, Ltd. |  | Brewster
 |  | US | China | Zhejiang Tianxin Pharmaceutical Co |  | Bridgewell
 |  | US | China | [NAME] |  | Bunge
 |  | US | Czech Republic | Lonza |  | California Cereal
 |  | US | Denmark | CHR Hansen |  | California Nature Products
 |  | US | Denmark | [NAME] |  | California Oils
 |  | US | Denmark | HOCO |  | California Oils/Venturra
 |  | US | Finland | Danisco |  | Cargill
 |  | US | France | DSM |  | Cargill/Tate & Lyle
 |  | US | France | Rhodia |  | Cereal Ingredients
 |  | US | France | [NAME] |  | Chattem
 |  | US | Germany | Amino GmbH |  | Chempoint
 |  | US | Germany | BASF |  | [NAME]
 |  | US | Germany | BMI |  | Clasen Quality Foods
 |  | US | Germany | DSM |  | Colloids Naturels
 |  | US | Germany | Jungbunzlauer [NAME] |  | Comax Manfacturing Corp.
 |  | US | Germany | Merck |  | Compound Solutions
 |  | US | Germany | Milei |  | Concord Foods
 |  | US | Germany | Nutrinova |  | Corn Products
 |  | US | Germany | Palitinit |  | [NAME]
 |  | US | Ireland | Glanbia |  | Creative Food Ingredients
 |  | US | Ireland | Kerry Ingredients & Flavours |  | Creative Research Mangement
 |  | US | Israel | Gadot Bio Chem |  | Danisco
 |  | US | Italy | Cargill |  | [NAME]
 |  | US | Italy | [NAME] |  | Degussa USA
 |  | US | Japan | Ajinomoto |  | [NAME]
 |  | US | Japan | Daiichi Pure Chemical |  | DFA
 |  | US | Japan | [NAME] |  | Domino
 |  | US | Japan | Kyowa Hakko USA |  | DSM
 |  | US | Japan | Nichiri |  | [NAME]
 |  | US | Japan | Nissui Nippon [NAME] |  | [NAME]
 |  | US | Japan | [NAME] |  | Far West Dist. / Humboldt
 |  | US | Japan | [NAME] |  | Farbest
 |  | US | Korea | Meiji Seika Kaisha Ltd |  | Fina
 |  | US | Malaysia | Sternchemie GmBH & Co. |  | Firmenich
 |  | US | Malaysia | Was [NAME] |  | FMC BioPolymer
 |  | US | Mexico | Cargill |  | [NAME]
 |  | US | Mexico | Rhodia |  | Fortitech
 |  | US | Mexico | Sesajal S.A. de C.V. |  | [NAME]
 |  | US | New Zealand | New Zealand Milk Prod |  | Friesland
 |  | US | New Zealand | [NAME] |  | Gadot
 |  | US | Philippines | SC Global Coco Products Inc. |  | General Chemical
 |  | US | Scotland | DSM |  | Givaudan
 |  | US | Singapore | Tate & Lyle Singapore Pte Ltd |  | Glanbia
 |  | US | Spain | Algry |  | Golden Peanut Company
 |  | US | Switzerland | DSM |  | Golden Select Foods
 |  | US | Switzerland | Lonza AG |  | Grace Davision
 |  | US | The Netherlands | Archer Daniels Midland Cocoa |  | Grain Millers
 |  | US | The Netherlands | DMV International Nutritionals |  | Grain Processing
 |  | US | The Netherlands | Friesland Foods Domo |  | Grower Direct
 |  | US | The Netherlands | Gerkens |  | GTC
 |  | US | US | Vitamins |  | Helm
 |  | US | USA | Abitec Corporation |  | [NAME] and White (Jimbo's Jumbos)
 |  | US | USA | ADM Specialty Ingredients |  | [NAME] and [NAME] (Ocean Spray)
 |  | US | USA | Agropur, Inc. |  | [NAME]
 |  | US | USA | Ajinomoto |  | Idaho Milk Products
 |  | US | USA | Amresco, Parent Company is VWR Scientific |  | IFF
 |  | US | USA | Archer Daniels Midland Company |  | Imperial Sugar
 |  | US | USA | Arro Corporation |  | JLS Foods
 |  | US | USA | Ashta Chemicals Inc. |  | [NAME]
 |  | US | USA | [NAME] |  | Jost
 |  | US | USA | Autocrat, LLC |  | Jungbunzlauer
 |  | US | USA | BCP Ingredients |  | Kerry
 |  | US | USA | Bell Flavors And Fragrances |  | [NAME]
 |  | US | USA | Brewster Dairy |  | Lawrence Foods
 |  | US | USA | Bunge |  | Leprino
 |  | US | USA | California Oils Corporation |  | Lipoid
 |  | US | USA | Cargill |  | [NAME]
 |  | US | USA | Cargill Corn Milling |  | LOL
 |  | US | USA | Chattem Chemicals, Incorporated |  | Lonza
 |  | US | USA | Corn Products |  | Mane
 |  | US | USA | [NAME] |  | Mariani Packaging
 |  | US | USA | Creative Research Management (CRM) |  | Marroquin
 |  | US | USA | DairiConcepts Incorporated L.P. |  | [NAME]
 |  | US | USA | DairyChem Labs |  | Merck-Millipore
 |  | US | USA | Danisco |  | Michigan Milk
 |  | US | USA | DFA |  | Michigan Sugar
 |  | US | USA | DMC |  | Milei
 |  | US | USA | [NAME] |  | Miller's Honey
 |  | US | USA | Dow |  | MTI Material
 |  | US | USA | DSM |  | [NAME]
 |  | US | USA | [NAME] |  | Nellson Nutraceutical
 |  | US | USA | Emerald Performance Materials |  | Norben
 |  | US | USA | Felda Iffco North America, LLC (FINA) |  | Ocean Nutrition
 |  | US | USA | Firmenich |  | Ocean Spray
 |  | US | USA | Florida Crystals |  | Ohio Chemicals
 |  | US | USA | FMC Biopolymers |  | Ottens
 |  | US | USA | Formerly Cognis |  | Pacific Coast Chemicals
 |  | US | USA | Fortitech |  | [NAME]
 |  | US | USA | Fortitech, Inc |  | Pretzels Incoporated
 |  | US | USA | FrieslandCampina USA LP |  | Prinova
 |  | US | USA | Fuji Vegetable Oil |  | Proctor and Gamble
 |  | US | USA | General Chemical |  | Prova
 |  | US | USA | Giles |  | Richmond Baking Company
 |  | US | USA | Givaudan |  | Robertet
 |  | US | USA | Glanbia |  | Roquette
 |  | US | USA | GPC |  | RV Industries
 |  | US | USA | [NAME] |  | Sensient
 |  | US | USA | [NAME] |  | Sensient
 |  | US | USA | [NAME] |  | Sethness Products
 |  | US | USA | Humboldt Creamery |  | Siovation
 |  | US | USA | Idaho Milk Products, Inc. |  | [NAME]
 |  | US | USA | International Flavors & Fragrances |  | Specialty Minerals
 |  | US | USA | Jost |  | SPI Group
 |  | US | USA | [NAME] |  | [NAME]
 |  | US | USA | Land O'Lakes |  | Stonstegard Food
 |  | US | USA | Leprino |  | Sun Opta
 |  | US | USA | Liberty Vegetable Oil |  | Suppliers
 |  | US | USA | Lonza |  | Sweetener Products
 |  | US | USA | Macron Chemicals |  | Symrise
 |  | US | USA | Mastertaste |  | Synergy flavors
 |  | US | USA | Michigan Milk |  | [NAME] and [NAME]
 |  | US | USA | Michigan Sugar |  | Tatua
 |  | US | USA | [NAME] |  | [NAME]
 |  | US | USA | [NAME] |  | [NAME]
 |  | US | USA | National Sugar Marketing LLC is the parent Company |  | TSI
 |  | US | USA | Nexcel |  | UDAZ
 |  | US | USA | Oil Seeds |  | Univar
 |  | US | USA | [NAME] |  | Valley Milk
 |  | US | USA | PQ Corporation |  | Vitamins Inc
 |  | US | USA | Previously Martek Biosciences Corporation |  | Vitusa
 |  | US | USA | Procter & Gamble |  | Watson Foods
 |  | US | USA | Rhodia |  | Wixon
 |  | US | USA | Roquette
 |  | US | USA | Sensient
 |  | US | USA | Sensient Pharmaceutical Technologies
 |  | US | USA | Sethness Products Company
 |  | US | USA | Siovation, Inc
 |  | US | USA | [NAME]
 |  | US | USA | Specialty Minerals
 |  | US | USA | [NAME]
 |  | US | USA | Stepan Company
 |  | US | USA | Stratus Foods, ACHumko, ADM
 |  | US | USA | SunOpta
 |  | US | USA | SunOpta ([NAME] for DairyChem Inc.)
 |  | US | USA | Symrise
 |  | US | USA | Tate & Lyle
 |  | US | USA | [NAME]
 |  | US | USA | United Dairymen Of Arizona
 |  | US | USA | Valley Milk Products
 |  | US | USA | Valley Queen Cheese Factory, Inc.
 |  | US | USA | Vanlab
 |  | US | USA | Ventura Foods
 |  | US | USA | Vitamins
 |  | US | USA | Vyse Gelatin Co.
 |  | US | USA | Wapsie Valley
 |  | US | USA | Watson Foods
 |  | US | USA | Wixon Inc.
 |  | USA | USA | Fortitech