In Qlik Sense, how do I combined two different rows?

[Coolavin]

I have a table with student data. the students each have row for each exam they took. I need to merge the rows somehow so that each student has one row with each exam grade taking up one column. There are only two exams. Is there an easy way to do this?

For example in the example below I need these two records into one row and really just the exam grade into one or the other row. 

[Quy_Nguyen]

Is this what you want? Just create a Pivot table and follow the settings in picture below.

Aww I don't know why I could not add an image here. Please view it in the attachment

[Quy_Nguyen · Accepted solution]

Try a Pivot table like this:

[Coolavin]

Yes! thank you very much, that really helped. I do have one more question though. 

If both exams are passed is there a way to hide those records? Seems like I would have to create some logic on those specific columns in the pivot table but I am not sure how to do that.