• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Filtering List and replacing remaining values with null

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
 
Back
Top