rearranging a table
 

Is there a way to rearange a table with 3 columns
from:

Class Topic Name
A English Marc
B Math Dan
C Math Lisa
A English Jhon
A Math Dave
B History Ling

To:

English Math History
A Marc Dave
Jhon
B Dan Ling
C Lisa

I have tried pivot table but does not work.
Any idea?
Many thanks,
Dan