Filter data and table not using power query

Frequent Contributor

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?

0 Replies