I am working on a KPI database I was assigned to make for a company project, and I have a filter set up so that I can filter all of the customers for the KPIs at once, across multiple data sources.

One of the data sources has slightly differently named customer names than all the others (ex. “Company Name” on one and “Company Name LLC” on the other, so the KPIs tied to that particular data set are not being filtered properly.

I do not have the capability to go in and change the names, this is a large company database, so is there any way to manually go in and specify which customer names are equivalent to each other across these two data sets?

I have the customer name fields linked already, that was easy, but I need to manually link the names themselves.