The problem with using a pivot table is that it won't simply list the values
- it wants to aggregate them. I'm already using one in another part of the
workbook for that very purpose :)

I just need to copy the middle columns based on what's in the department and
show title columns and paste it on a different worksheet.