Re: Provide list from all columns marked with and "x"

Select the 1x5 array of column labels and name it items
Select the 3x5 array of x's and name it arrayX
Insert > Name > Define > arrayB
Refers to: =IF(arrayX="x",items,"")
Select the three cells in column B and enter this array formula
with Ctrl+Shift+Enter
=CONCATENATE(INDEX(arrayB,,1),INDEX(arrayB,,2),INDEX(arrayB,,3),
INDEX(arrayB,,4),INDEX(arrayB,,5))

.