Filter by name and include column headers if they contain a value

Question

I have the following data:

and would like to create a separate sheet that would Identify the First name, Last name and the header of columns E:N if they have a value of 1.

I would like to have the separate sheet include a dropdown list of names in column A1 to populate the data.

Answer 1

UNTESTED (what, with that much data and in a barely legible image ?!)

Copy the entire populated part of your spreadsheet below existing data (say to A100) and fill the central area (starting E101) with:

 =if(E2=1,E$1,"")

Count row contents with:

=countunique(E101:N101)

in O101 and fill down to suit.

In your other sheet:

 =FILTER({Sheet!A101:B201,Sheet!E101:S201},Sheet!O101:O201>0)