Excel - How to filter to show subset of questions for selected criteria

HansVogelaar 

Thanks!! However, I noticed that the filter works if there is "Y" indicated in every column but fail to work if there is say a "blank" or "N" in the appropriate cell in the respective column.  Is there something that I am missing or is that how Advanced Filter works? How do I get the filtered questions without having to delete the columns not needed and reapplying the filter? The reason why I am asking this is because the filter is to be used by end-user and I am hoping for a more elegant solution. 

Many thanks in advance!!