Forum Discussion

DavidQuinonez's avatar
DavidQuinonez
Qrew Member
9 years ago

How to align multiple entries, similar but not exact, that are assigned to a number to become exact?

I am researching a program that would "sync" data that we have for a large amounts of data for one of out largest clients in the US. Specifically when I say "sync", there are multiple supplier ...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
9 years ago
Another solution is pure excel.
Make a pivot table of unique Supplier IDs. or make a summary report in QuickBase of unique Supplier IDs.

Copy those unique entries ot a new sheet.

Use a vlookup in excel to lookup the supplier name.  It will find the first entry it find son the list and take that spelling as correct.