How can I transform a row in excel based on condition using formula.
Like here three column A, B, C. If a column contain yes then the name of the header add to the activities column in a new row. Here example

Before:

name    | A     | B       | C
name1   | yes   | yes     | no
name2   | no    | yes     | yes
name3   | yes   | no      | no

After:

name    | Activities
name1   | A
        | B
name2   | B
        | C
name3   | A

now write formula