Forum Discussion
Solved
Create a list of columns with value per row
Subject probably makes no sense so let me explain with an example: A.1 A.2 A.3 A.4 A.5 A.6 A.7 A.8 DESIRED RESULT #001 1 3 4 A.1, A.4, A.5 #002 ...
=BYROW(B2:I9,LAMBDA(row,TEXTJOIN(",",,FILTER(B1:I1,NOT(ISBLANK(row))))))You can try this formula.
=BYROW(B2:I9,LAMBDA(row,TEXTJOIN(",",,FILTER(B1:I1,NOT(ISBLANK(row))))))You can try this formula.