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!