Excel 2007 Student Edition:

How do I combine values from multiple rows about 1 item into 1 row about
that item?

For example:

Header: Year Title A B C
Row 1: 1997 Titanic 4
Row 2: 1997 Titanic 3
Row 3: 1997 Titanic 1
Row 4: 1999 Matrix 2
Row 5: 1999 Matrix 1

Into:

Header: Year Title A B C
Row 1: 1997 Titanic 4 3 1
Row 2: 1999 Matrix 2 1

I have about 3000 rows of items, and 40 columns of values, and I'd prefer
not to spend a whole day combining these by hand.

Thanks,

Greg