Forum Discussion
How do i filter from a table
1 2 3 4 5 6 7 8 9 Andy x x x x Bob x x Moh x x x x Stu x x x x Zee x x ...
=LET(arr,LAMBDA(x,CHOOSE(x,A2:A6,SEQUENCE(ROWS(B2:H6)))),
MAP(arr({1}),arr({2}),LAMBDA(a,b,a&" - "&TEXTJOIN(", ",,FILTER(B1:J1,CHOOSEROWS(B2:J6,b)="x")))))
=BYROW(SEQUENCE(ROWS(A2:A6)),LAMBDA(r,CHOOSEROWS(A2:A6,r)&" - "&TEXTJOIN(", ",,FILTER(B1:J1,CHOOSEROWS(B2:J6,r)="x"))))These formulas return the expected result if i correctly understand what you are looking for.