I have a list of vendor names and addresses I need to match based on the same address name but different vendor names For example if this is my sample input data: Vendor NameStreetCityCodesAdobeOrchard ParkwaySan Jose95134CiscoPark AveSan Jose 95110SalesforceSan AvenueSan Jose95119AlteryxWest DriveSan Jose95134UiPathAlameda streetSan Jose95126 How do I solve this?

I am sorry but I don't have any information either on that at the moment Here is what I can tell you I need to find name duplicates, under that I need to For dups, we can do the following matches Matching based on same address but different names Hope this helps

Hi @Bhoomika_Rasquinha Sorry I didn't get your requirement clearly. Its unclear what I need to assign with different names and same address. What to assign if it has only same address and name. What to do if many different names and address are there.

Hi, I need to perform matching based on different names but same address U and D is for convenience

Finding duplicates against a constant column

Bhoomika_Rasquinha

I have a list of vendor names and addresses
I need to match based on the same address name but different vendor names

For example if this is my sample input data:

Vendor Name	Street	City	Codes
Adobe	Orchard Parkway	San Jose	95134
Cisco	Park Ave	San Jose	95110
Salesforce	San Avenue	San Jose	95119
Alteryx	West Drive	San Jose	95134
UiPath	Alameda street	San Jose	95126