Give in 1 cel the column names of all cell's that are indicated with an x.

In each row, some cells are indicated with X.
The goal is to have for reach row, a cell that gives all column names that are indicated with X.

I've managed to solve this by adding 3 columns with IF functions (AI - AK) and merge them together.
I was wondering if there is a shorter way of doing this.

Anny sugestions?
Thanks!

I don't have 365 but I think TEXTJOIN is the required function

Hi & welcome to the board.
As John has said you can use textjoin

Formula:

Please Login or Register  to view this content.