I have a spreadsheet used to track employee performance in different disciplines. What I'm trying to accomplish is a drop down menu where based on user selection all blank cells in a given column will be filtered out. As you can see from the screenshot below, the first column contains an analyst name and the following columns each contain a specific discipline. Each row represents a different employee. Not all employees have a score in every discipline. What I'm hoping to accomplish is a drop down box containing each discipline (Biology, Chemistry - CS, Firearms Proc, etc) where when you select Biology for instance, all rows without a score in Biology are filtered out. I know this could be accomplished easily using the basic filter on each column, but I am trying to accomplish it using a drop down box specifically.

I was able to create a drop down menu to filter by employee, but I am really struggling to accomplish this specific task. I appreciate any help.. thank you!

Capture.JPG