Filter data by the department number of each employee

[Gummyworms1234]

We are ordering equipment for our employees and I want the raw data of everything I have filtered by department. I could copy and paste each one to go with each department but we have too many employees throughout all three shifts and it would take forever to do it manually. I was thinking a pivot table would help but I wasn't able to get it to do what I wanted. I would like everything filtered out by department so I can send all three departments a list of the employees with the equipment they need to order. The picture I've attached is a simplified version of what I am currently working with. Thanks for the help!

 

[Gummyworms1234]

Could you upload a sample workbook to a free site such as dropbox.com or google drive & then share the link here?
It will make it easier to test and find a solution.
Or at least post your samples as table instead of image, using XL2BB is preferred.

My coworker was able to work his magic and help me with what I needed yesterday! Thanks for the help!