How to show a row in excel if there is a X

Question

I'm busy learning Excel, but I have to provide a formula to the pupils who passed. The names and grades of everyone with a "X" next to "exam passed" must appear under "who passed?" Who Passed? does not require all of the students without a "X" behind their names to appear.

I attempted an if statement, but I am not receiving the desired outcomes.

Answer 1

FILTER Function: "filters" a range of data based on supplied criteria(X). The result is an array(B2:E7) of matching values(X) from the original range(G2:G7).

=FILTER(B2:E7,G2:G7="X")