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

I have a set of  500 questions for different interest groups in a spreadsheet. The questions are tagged "Y" if it is applicable to a specific interest group. See table below.  Is there a way t...