Combining data in non-adj rows

I have a spreadsheet that pulled data for all sales reps for 2006-2007 by month, and by account #. My challenge is that one rep quit and another rep took her place. But the data harvest shows both reps data. Exa

Rep Jan 06 sales-----------Dec 06
John Smith $50,000 $0.00
Becky Sue $ 0.00 $30,000

I want to combine the data under the current rep, and do a comparison between years 2006 and 2007. I can move all of John's data into the row(s) for Becky, and then sum it, but the problem is that there is about 15k rows of data. I was wondering if there is a quick fix to this problem.

As always, any help is appreciated. MK

Not sure if I understand exactly what you are looking to do, but from my understanding... You have data that looks like this...

|-A-|-B-|-C-|-D-|
|-Becky-|-Sue-|-$0-|-$30,000-|
|-John-|-Doe-|-$20,000-|-$15,000-|
|-John-|-Smith-|-$50,000-|-$0-|

And you want it to read...

|-A-|-B-|-C-|-D-|
|-Becky-|-Sue-|-$0-|-$30,000-|
|-John-|-Doe-|-$20,000-|-$15,000-|
|-Becky-|-Sue-|-$50,000-|-$0-|

In which case I would recommond doing an Auto-Filter (Data->Filter->Auto Filter) and then Filtering on John and Smith and just replace John Smith with Becky Sue for the two columns...

Then to pull the sum you could use =Sumproduct(--($a$1:$a$100="Becky"),--($b$1:$B$100="Sue"),$c$1:$c$100)

Although with that I'd recommend adjusting the 1-100 range to the range of the data...

Hope that helps...
John