List to crosstab/broadsheet

[timetabler]

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 table gives me a count or sum of values. I have a very quick macro for converting from a crosstab to a list but it seems very difficult to go the other way.

 

[Jubjab]

How exactly does 2 source rows change into 6 result values? I.e. where does the C, B come from on target row 1 and D, A on target row 2?

 

[timetabler]

Apologies! I didn't check my two examples,


The data in the list I have is:
ID, Subject, Grade
1, Subject1, B
1, Sbuject2, C
1, Sbuject3, B
2, Subject 1, C
2, Subject 2, C
2, Subject 3, A

I want a crosstab of:
ID, Subject1, Subject2, Subject3
1, B, C, B
2, C, C, A