How to insert multiple filters to filter one persons name from different column

[pupadhya]

Dear All,

We are into aviation training; and we have several instructors conducting classes different batches, so I have created Excel file along with Batch details and I have assigned Instructors as per the classes according to the date. Now I have excel sheet where 4 batches are running simultaneously and I have assigned same instructor into different batch as per his availability.

My requirement:

I wanted to filter Instructor name across different batches, so that I get to know his utilization into different batches and when is he busy doing what classes.

Example: I have file table like this:
CLASS/TIME SFI GSI
ELT-GS/1000-1800 DEV GHOSH

I have the above table for multiple batches, so now when I filter, I would like which batches where SFI(Instructor) DEV GHOSH involved across all the 4 batches in the table.

I have attached my file for your reference, please help me how can i inert multiple filters into different batches so that i get to know the utilization of one instructor.

I have also posted my problem in other forum, please find the link below:
How to insert Multiple Filters or Write VBA or Excel way to filter
Please help.
Regards,
Pramod