Changing 1 column in to multiple rows for multiple columns

[jrma91]

High all,

 

Is there a quick and easy way that I can change a table like the one below....

 

Name ......Subject...Grade

Joe Bloggs Art C

Joe Bloggs DT D

Joe Bloggs Sci C

Joe Bloggs Hist D

Joe Bloggs Geog D

Joe Bloggs Math C

Jane Doe Art A

Jane Doe DT B

Jane Doe Sci A

Jane Doe Hist C

Jane Doe Geog B

Jane Doe Math A

Sue Smtih Art E

Sue Smith DT D

Sue Smith Sci E

Sue Smith Hist F

Sue Smith Geog D

Sue Smith Math A

 

To look like this....

 

Name........Art DT Sci Hist Geog Math

Joe Bloggs C D C D D C

Jane Doe A B A B C A

Sue Smith E D E F D A

 

I have over 2000 rows to of data an don't want to paste transpose each and every single person!

 

Any help would be most grateful!

 

regards

 

jrma