Filter on multiple fields together

Question

Hi, I have a data structured as shown below. I want to apply filter on multiple fields together i.e. I want to extract the fields marked in yellow. I have a fairly large dataset and this exercise needs to be repeated across multiple fields-so don't really want to filter out by the first column and then add in another filter for 2nd column to achieve this output-is there a dynamic way for achieving this ?

Multiple field filter.PNG

binu_acs · Accepted Answer

@Shaina1 One option is to transpose your data and apply the filter then cross tab the result

messi007 · Accepted Answer

@Shaina1,

You can use Transpose -> Filter -> Corss Tab:

Hope this helps!

Regards,