I have a worksheeet full of data which I did not create. The data conforms
to all the requirements for a pivot table and I'm able to create a pivot
table; however, the pivot table is showing a duplicate manager name. I have
to add the data together to get the correct amount. Here is an example:

Smith 10 hours
Smith 20 hours
Total 30 hours

Can you help me determine why the manager "Smith" is showing twice instead of:

Smith 30 hours

Thanks!