Forum Discussion
Solved
SWITH Command to Change Only One Value in a Column
I have a column with over 10,000 values, of which there are about 50 distinct values. I want to perform a Switch command on just 1 value and leave the other 49 values the same as they current are. ...
You could create a new conditional column in Power Query along the lines of
if Text.Contains([Column], "SOP") then "SOP" else [Column]
and then delete the original column
Exactly what I needed! Thank you!