Forum Discussion
filtering subjects which have value "10" and arrange subjects in one cell for each student
I have to arrange of data as shown in the attached file. I need to list subjects for each student such that in this subject, the student value is 10. Note that the subject should be arranged in one c...
=LET(table,A7:E10,subject,DROP(TAKE(table,1),,1),name,DROP(TAKE(table,,1),1),HSTACK(name,BYROW(DROP(table,1,1),LAMBDA(row,TEXTJOIN(",",,FILTER(subject,row=10))))))With Office 365 or Excel for the web you can try this formula.
Not working on google sheet