How to change a value to one that already exists without being identified as different in PowerQuery

[jcordovacor]

Hello All,

I am trying to change a value called "undergraduate research" to "research" in one column. The value "research" already exists in that column. When I make this change with the following replace function (= Table.ReplaceValue(#"Replaced Value","undergraduate research","research",Replacer.ReplaceText,{"Institution Labels Name"}) ), I see the value changed to "research" but it is identified as a different value than the original "research" (in the 1st image they are identified as different values). My goal was to have the counts by "research" and "research" (previously "undergraduate research") get added in a PowerBi visual (2nd image). I would like to know how to fix this, thank you for your help.

[ppm1]

Perhaps you have hidden characters or leading/trailing spaces. Try doing a Clean or Trim on that column after you replace values.

Pat