Row Level Merge and delete

Datology

Hello All,

I have the following data set

When a UNIT has a SUB_UNIT A that matches with a SUB_UNIT B. I need to remove the SUB_UNIT B row and replace the A with a W. One UNIT and SUB_UNIT can only be matched with one other UNIT and SUB_UNIT. So the result should look like this...

Is there any way to do this outside of using Python?

Appreciate any help you can give!

Qiu

@Datology 
Thnak you for the input data.

Your new input indeed requires some addtional settings.

Kindly see this works for you.

0328-Datology.yxmd