Loop through rows based on condition

[charlie2]

Hi,

I have the following table with prices per customer and price category:

Customer	Price	Price Category
X	0,5	A
X	0,7	B
Y	0,5	A
Z	0,7	B

My goal is to keep the rows for each customer of price B, in case they exist, otherwise, keep price A.  So price B prevails over price A. The desired result would then be to have the same table but without the first row:

Customer	Price	Price Category
X	0,7	B
Y	0,5	A
Z	0,7	B

Any suggestion on how to do so in the data editor?

Thanks in advance