....but you only want to show "Options" once even if it's selected more than once? There isn't a "native" formula that can concatenate an array but you could use concatenated IF functions, e.g. in B5 copied down

=SUBSTITUTE(IF(D5="x",", "&D$1,"")&IF(E5="x",", "&E$1,"")&IF(F5="x",", "&F$1,"")&IF(G5="x",", "&G$1,"")&IF(H5="x",", "&H$1,"")&IF(OR(I5="x",N5="x",Q5="x"),", "&I$1,"")&IF(J5="x",", "&J$1,"")&IF(K5="x",", "&K$1,"")&IF(L5="x",", "&L$1,"")&IF(M5="x",", "&M$1,"")&IF(O5="x",", "&O$1,"")&IF(P5="x",", "&P$1,"")&IF(R5="x",", "&R$1,"")&IF(S5="x",", "&S$1,"")&IF(T5="x",", "&T$1,"")&IF(U5="x",", "&U$1,"")&IF(V5="x",", "&V$1,"")&IF(W5="x",", "&W$1,"")&IF(X5="x",", "&X$1,"")&IF(Y5="x",", "&Y$1,""),", ","",1)

regards, barry

=SUBSTITUTE(IF(D5="x",", "&D$1,"")&IF(E5="x",", "&E$1,"")&IF(F5="x",", "&F$1,"")&IF(G5="x",", "&G$1,"")&IF(H5="x",", "&H$1,"")&IF(OR(I5="x",N5=

regards, barry