Pull row/column titles based on values inside an array

[julzzzz]

Hi all! Glad to finally join the forums

I have an excel problem that goes like this:

Input: I have a large table with "persons" in rows and "characteristics" in columns. For every person, there are 2 or 3 "1"s indicating which characteristics they have.

Output: I want to generate a report in table form that shows for each person, what are the characteristics they manifest under columns "Characteristic 1", "characteristic 2", "characteristic 3" with the under each being the column titles on the input table. Please note that the output table should display a lot of people with different characteristics each, so filtering blanks is not possible (i think)

Would appreciate if someone can put me in the right direction

[Pete_UK]

I would suggest that you post an example workbook, then you might get someone prepared to look at it for you.

Pete