I am trying to "clean up" a data sheet so that I can run a drag down command.
The data looks like this:

Name Type Score
John AM 4
John AM 5
John LI 3
John RI 7
John RI 7
John RI 6
Dave AM 4
George AM 6
George LI 5
George RI 4

I would like to turn that into this

Name Type Score
John AM 5
John LI 3
John RI 7
George AM 6
George LI 5
George RI 4


So basically there are three types; AM, LI, RI and I want to take the
highest score for each type and delete any other score. The catch is, if the
person doesn't all three have 3 types, then I have to delete them. Can
anyone help me?