I would like to know if there is a way to to merge lines in excel, sum a
number, then do the same for the next person-- for instance:

ID name start end salary
1235 John doe 1/1/05 1/31/05 100
1235 john doe 2/1/28 2/28/05 200

(summary) 1235 john doe 1/1/05 2/28/05 300