Forum Discussion
Solved
Replacing all non-null values
This is probably a fairly simple query, but I cannot work out how to do it. How can I replace all values that are not null across multiple columns with the word Yes. Thank you!
Sorry.
Then I would probably add a conditional column
IF [column] = null then NULLELSE [column]
This calculated column will have your cleaned up values. Then you can hide the original one.
As far as I know the "Replace value" function does not have what you need.
Yes, you can do it with the Replace Values function!
In this table, column headed "F01" has empty cells that are not "blank"
Select the column or click into a cell within it. Now right-click, and select Replace Values.
Leave the top "Value to Find" box as is. In the lower box, type "null"
click "OK"
Now we have "null" in all the formerly blank cells! yay!