Remove Values in column

Question

Can I remove the highlit values based on Column A (Name)? For example, in the picture below, I'm trying to remove the values in column C 200,000, and 52,221. which is the last name on the list of common names in column A (Name). But I just want to remove the values, not the whole rows.

v-yalanwu-msft · Accepted Answer

Hi,&nbsp;moatazbelah&nbsp;;
You could replace this values in power query ro null.such as:

The final output is shown below:

Or add a custom column then delete origin column.

Best Regards,Community Support Team _ Yalan WuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
&nbsp;