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 cell separated by"," and I am using google sheets. see attached file
=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
