filtering subjects which have value "10" and arrange subjects in one cell for each student

[ajl_ahmed]

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 

[#2]

@ajl_ahmed 

=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.

[#3]

Not working on google sheet