Filter data and table not using power query

I have two attempts of exam and each attempt consists from 14 subjects. I want to filter these two attempts for passing marks (mark>=50) and construct the table as below. Is there any formula or function to do this?