How to preprocess rows in MS Excel to create series data based on common column values

I have several hundred rows of data where one column contains students names, one column contains an assignment ID, and one column contains scores. I am looking for way in MS Excel to preprocess the data set, either using built in functions or VB macros in such a way to organize the scores into a series labeled by the students name. If possible I would like to use assignment id’s for y axis labels when I graph. Is there a macro or function for preprocessing data like this in MS Excel?

     A.        B.         C. 
1   Name      ID         Score
2   Al        1000       97%
3   Rob       1000       93%
4   Jack      1000       95% 
5   Al        1001       92%
6   Rob       1001       97%
7   Tim       1001       98%
8   Jack      1001       93%

Transforms to

 A.         B.         C. 
1 Name       1000      1001
2 Al         97%       92%
3 Rob        93%       97%
4 Jack       95%       93%
5 Tim                  98%

Update：
Try to insert a PivotTable.