Assemble equal data after using the function Table.ReplaceValue

Hi Anonymous ,

In addition to bcdobbs 's reply, please try Trim function in Power Query.

Here I have a test by add space front or behind "Apple". We can see there are three Apples which look like the same in Filter. 

I find Clean function couldn't remove them. Try trim, it will work.

Or find all different "Apples" by filter , copy them and compare them to find the difference.

For reference: Trim Vs Clean in Power BI and Power Query

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.