In Qlik Sense, how do I combined two different rows?
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.