Combine two rows and add values while remove one of the rows

Hello my name is Alex and I am a manager for a few cell phone stores and I need some help.
So basically I have two separate rows in an excel file containing a rebate reimbursement for a single phone number but my POS is currently unable to match the two numbers and reimbursement amount together. This is what I'd like to do as easy as possible.

-Match duplicates in a row (Phone numbers) Ex:Column A
-add the two value together (Rebate Amount) Ex: Column C
-Delete 2nd row after I get the sum

Normally it wouldn't be an issue for me because I used to do this manually but they just promoted me to District Manager and now I have multiple store to take care of and doing it manually is really time consuming.

In case I wasn't clear I attached an example. This is a very small version of what I am dealing with.


Anyone that could help, would be doing me a great service.


PS. File must remain in the same format, I don't think pivot table will actually assist

Just for the sake clarification. I will update the Excel file to show what I have and what I'm trying to achieve.