How to update inconsistent data

[Learner09]

Hello,

I am looking for a solution for a problem in which I need to update data on the basis of customers, but there are some data that is inconsistent. Could anyone help me to design a solution? I have attached the file with details and sample data

[rohityaman]

Here is one solution: