Remove Values in column

[moatazbelah]

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 solution]

Hi, @moatazbelah ;

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 Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

What is the basis of deciding the order of appearance of each row for each name?