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?
