Forum Discussion
Jeffrey T
Dec 15, 2022Copper Contributor
Find and replace comma separated values
Hello Everyone, I was provided an Excel sheet that has users in one column and the companies they belong to in another column, some with more than one group. username company john.smit...
Lorenzo
Dec 15, 2022Silver Contributor
Hi Jeffrey T
A possible approach with Power Query function Table.FuzzyNestedJoin and options:
IgnoreCase=true, IgnoreSpace=true, Threshold=0.5
If more than 1 match the query keeps the one with highest similarity