Hello bgreer and welcome to the forum.
I think you need to create a summary from your table.
Make the KEY fields
and the MEASURE will be HOURS.
Right-click on the TYPE field key and in the properties settings for DISPLAY change the 'Down' selection to 'Across'. That will give you a column for each TYPE that occurs and seems to be what you need.
You may also like to consider making another summary just the same but with the key re-ordered
That would give you the ability to drill up and down and aggregate the measure values by department as well as name.
See also the Help file section for "Display Key Values Across in a Summary".