Zend certified PHP/Magento developer

Combining information 2 data sets in excel where rows don’t match

I have two sets of simple data in excel (name and amount) from two sources and the rows do not match. I would like to combine so that I get a total per name. How do I do so?