Hi Team,
I have a column in which we have specific names and their duplicate one also. For example we have 'Sam/ Mohd and Sam/M' i should be changed to one name either of name 'Sam/Mohd or Sam/M.
Another example 'Main James/ Huss and Main J/ Huss'
Do we have anything to find and sort this out? Please find attached.
Thanks in advance.
Name |
Sam/ Mohd |
Main J/ Huss |
Sam/M |
Huss Fuss/ Corola |
Sameer Sa/ Gail |
Huss Fuss/ C |
Sam/Mohammad |
Main James/ Huss |
Asad Moa/ Main |
Tres Sagar/ Ani |
Agr/Nav M |
Agr/Nav |
Ash/ Tam |
Tam/Ash |
Kar Anr/ Say |
Kar Anr/ S |
Agr/Nav Mr |
@mmustkee
I am not an expert but this Fuzzy match is always tricky and can not get what we really need.😂