Help Needed on Formula - Sum Qty when a Duplicate Name Exists

[emilyexcel]

Hi There, 

Looking for help. Have a list of Employee #s and when there is a duplicate, I would like to sum the hours in Column K and return the total in a New Column. all the better if it can also delete one of the duplicate rows in doing so, so I am left with a Total that corresponds to the one employee. Attached is a data sample and desired outcome example. 

[#2]

@emilyexcel Please find attached solution

If you are satisfied with the solution do mark this solution as best and official solution.

[#3 · Accepted solution]

@emilyexcel 

If you delete the empty columns from your data set, you may insert a Pivot Table to get the data in desired format.

Refer to the attached and look at the sheet called "Pivot Table" for more details.

[#4]

Nailed it--thank you!!

[#5]

You're welcome @emilyexcel!