0
How can I merge a list of companies with many duplicates but the duplicates aren't exact matches?
Account # First Name Last Name Company Address City ST
Lisa Miles Bills Industrial Supply 2212 E Main Street Denver
#41519456 Bill's INDUSTRIAL SUPPLY 2212 E Main Street
#41519456 Lisa M Bill's INDUSTRIAL CO
final version:
Account # First Name Last Name Company Address City ST
#41519456 Lisa Miles Bill's Industrial Supply 2212 E Main Street Denver CO
1You need to use a unique identifier to pinpoint duplicates, for example by customer number (41519456). Then handle those duplicates manually since there is no programmatic way to know which address or business name is more correct than another. – Moses – 2015-01-19T22:35:12.697