Hi...I have a sheet with data that looks like this...

Col A Col B Col. C Col D
joe part1 320
joe part 2 150
betty part 1 350
betty part 2 270

What I want to do is to create a new column of data which has all the
"scores" that each person received in part 2 of the test. So each person
would only be listed in one row...any ideas? Thank you!