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.


--
inprogress
------------------------------------------------------------------------
inprogress's Profile: http://www.excelforum.com/member.php...o&userid=26117
View this thread: http://www.excelforum.com/showthread...hreadid=394465