Removing Duplicates in one column and summarizing data

http://dl.dropbox.com/u/5892902/names2012.xlsI have a 5 column document with about 3000 entries that I need help streamlining. THe first column is a student's name, then grade. The next 2 columns are for Honour Roll Standing (A or B) and/or an Effort Honour Roll Standing (E). Finally there is also a "term" column indicating if they received this award is Term 1, 2 or 3.

An example source file is found here:
http://dl.dropbox.com/u/5892902/names.xls

As you can see, there are many students who have received an award in all 3 terms, however there are also some students that only recieved standing for 1 or 2 terms.

I need to manipulate the data so that there are no duplicate names and all the data regarding Honour Roll standings and which term it occured in are all laid out in one row per student.

IDEAL COLUMN HEADINGS:

NAME | Grade | Term1 HonourRoll | Term1 Effort | Term2 HonourRoll | Term2 Effort |

etc etc etc