The following forum(s) have migrated to Microsoft Q&A: Power Query! Visit Microsoft Q&A to post new questions.
Hello everybody.
I am trying to replace values in one column but only if where the value in another column has a specific value.
For instance, I want to replace all "1" with blanks in column A but only if the value in column B is "REPLACE".
Thanks in advance for any help!
You need to create an additional column and use a formula such as if [B]="REPLACE" and [A]="1" then "" else [A]
then delete column [A] and rename the new column in "A"