Yvonne Love
Member
I'm a super novice at Power Query, so I am still looking a lot of things up. I may not be phrasing this correctly, so please bear with me.
I'm trying to clean up data using Power Query, which so far has been really great. However, there is one column that has various values, including null, and I need to filter out the data I need to keep and then replace all remaining values with null. Essentially I need that column to contain either one of the values I filtered out (so as not to replace) or null. I know there is a replace values feature, but I can't do them one at a time (also, I may not know which values are in there or not) - so I am hoping there is some way to make the change to all of them at once to make them null. Is that a possibility?
Thanks,
Y
I'm trying to clean up data using Power Query, which so far has been really great. However, there is one column that has various values, including null, and I need to filter out the data I need to keep and then replace all remaining values with null. Essentially I need that column to contain either one of the values I filtered out (so as not to replace) or null. I know there is a replace values feature, but I can't do them one at a time (also, I may not know which values are in there or not) - so I am hoping there is some way to make the change to all of them at once to make them null. Is that a possibility?
Thanks,
Y