Returning selected column headers

Hi, I'm trying to do something where for each row in a table, I am trying to return the heading, if the column is selected. To better illustrate this, I included the table below:

Math English Science History
Jason X X X X
Michael X
Stephen X X


I'm trying to figure out a way so that can automatically return the column heading if I choose the row. So if I chose Jason's row, it would return "math, english, science, history". What is the best way that this can be done?

I also included a test excel document to further illustrate, in case the post doesnt come out right. Thanks guys!

I understand your spreadsheet layout but what do you mean by "choose a row"? Do you want to return somewhere else on the spreadsheet or in the workbook that Jason is taking Math, English, Science and History? Or do you want to replace the X's with the headings in that table?

ChemistB

Hi Chemist, I should clarify.

Somewhere else on the spreadsheet I'm going to label as Jason (hardcoded). And then I want a formula that returns all of the subjects that Jason is involved in.

Let me know if you guys need anymore points of clarification. Thanks!!

Nrage, yes that is exactly the kind of thing I am looking for! The only thing is, is there a way to make it so that if you were to add additional columns in between the existing ones, the formula will update and include these new headings as well? e.g. if I was to add Wood Shop between any existing subjects. Thanks.

Can anyone help me with this? I still can't figure out the way to do this

I don't think so. I think you'll have to just manually update nrage21's formula in C2. The formula in row 4 can just be copied over and the others shouldn't need to be updated, so it should be relatively easy to do.