Greg

You can try the below..

1. Select the range in Col A and B including the header.
2. DataFilterAdvanced FilterCopy to another location
3. In copy to I have selected G1 and check 'Unique records only'
4. Click OK will give you the unique list of year and title in Col G and H.
5. Now place the headers A,B,C in I1, J1, K1.
6. In I2 apply the below formula

=SUMPRODUCT(--($A$2:$A$100=$G2),--($B$2:$B$100=$H2),--(C$2:C$100))

Copy that to J2 and K2
Drag down as required.

If this post helps click Yes
---------------
Jacob Skaria


"Greg" wrote:

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