How do I group certain data from a spreadsheet

[RozRod]

I have an excell spreadsheet creating a log of investigations assigned to
certain investigators. How can I print out a list for each investigator with
all their respectively assigned cases?

 

[Duke Carey]

Data | Filter | AutoFilter

This will create little drop downs next to each column header. Select each
Investigator from the drop down and Excel will show you only the assigned
cases