Hello,
I have a spreadsheet with employee names and hours worked. Each employee has multiple lines with four columns. I want to have each employee have one line and to add the number of hours that is in the same column for that employee.

Name track track pp hrs
abrams, james 12.82 12.00
abrams, james 10.00 0 11.5
acker, edward 12.22 11.50
acker, edward 10.00 0 1


i can have hundreds of lines.

I want the outcome to look like this:

Name track track pp hrs
abrams, james 12.82 22.00 0 11.5
acker, edward 12.22 22.50 1 1

if there is a formula that can do this or a macro, please help.

Configuration: Windows XP
Internet Explorer 6.0