combing cells with same data

i did a search but nothing that i was looking for came up. maybe i wasnt searching the right terms. here's my problem.

i have a list of data

......a.....b....c....d.....e...f
1 john usa 876 675 454 345
2 bob china 34 545 034 000
3 bob china 03 000 0006 0002


i want to combine row 2 and 3 so it looks like this
bob china 37 545 40 2

it would be nice if the new added row replaced the previous row 2 and 3

i have a whole list of data.. about 3000 rows

any help would be appreciated.