I'm using office 2010 and I have two columns of data.

Column A is a list of names (currently 22, but can fluctuate)
Column B is a score for each name in column A.

I need to create a third column with pairing of each name in Column A. ( without duplication)
And a fourth column with a combined total of the score for each of the names combined.

Example:
Col A..........Col B............Col C...............Col D


John............100.........John & Steve.........250
Steve..........150..........John & Roy............220
Roy.............120..........John & Kirk...........230
Kirk............130..........John & Diane.........210
Diane..........110.........Steve & Roy...........270
................................Steve & Kirk...........280
................................Steve & Diane........260
................................Roy & Kirk.............250
................................Roy & Diane..........230
................................Kirk & Diane..........240

(Decimals used for place keeping to show columns)

Any help in how to do this would be grateful.