Filter and Drop Down List

Occasional Contributor
I was told to make a list of people in the department with different job qualifications. Only problem is that when choosing filter only one column is showing up and not the other. For example if I am to select filter Kiln Tender only the one in column C shows up and not the ones in column D,E,F, etc I need it to be able to show all the possible ones not one column. Any way to get this done or any other way I can do it? Would be appreciated
1 Reply