How to group rows of data with text

I am exporting a report that lists multiple employee names in column "B", column "C" is the payroll item (example: Hourly, Overtime, Double Time, A-Foreman, B-Foreman, etc.) and column "D" is the hours worked.  I want the columns to consolidate per Employee name in column "B" then by payroll item in column "C" and finally the total hours worked in column "D".  This would result in the same employee name consolidating into potentially multiple payroll codes.  I cannot seem to figure out how to get the payroll items to show up.  Maybe I am not thinking of the correct function that would work best for this scenario?  Below is an example of what I have for data layout and what I would like to see.

What the report provides:

Column B           Column C           Column D

Employee 1          Hourly                  5

Employee 2          Overtime              2

Employee 1          A-Foreman           1

Employee 2          Overtime               2

Employee 1          Hourly                   1

What I want to see:

Column B           Column C           Column D

Employee 1           Hourly                 6

Employee 1           A-Foreman          1

Employee 2           Overtime              4

I appreciate any help I may get!