I am trying to convert a list of data to a crosstab of data (a pivot table doesn't seem to work).
The data in the list I have is:
ID, Subject, Grade
1, Subject1, B
2, Subject 2, C
I want a crosstab of:
ID, Subject1, Subject2, Subject3
1, B, C, B
2, C, D, A
Converting the list via a pivot...