Jim:

Given the structure you posted, you won't be able to get a Pivot Table laid
out the way you want.....but....

You WILL get that layout if you use Data Consolidation:

<data<consolidate
Select your data range....click the [ADD] button
Use Labels in...
Check: Top Row
Check: Left Column
Click the [OK] button

OR

If you format your data this way, the Pivot Table will work:
Dbl Sgl Value
aa a 1
ab a 2
aa a 3
.. . .
.. . .
.. . .
ab f 4
ac f 5
af f 6

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"appleknocker" wrote:

I can't get the table to layout the way I want it to

Data

Row Col
a b c d e f
aa 1 1 1 1 1 1
ab 2 2 2 2 2 2
aa 3 3 3 3 3 3
ab 4 4 4 4 4 4
ac 5 5 5 5 5 5
af 6 6 6 6 6 6

I want to group the rows that are common and sum the colums in like rows.
The report result (summing the columns) should look like this

a b c d e f
aa 4 4 4 4 4 4
ab 6 6 6 6 6 6
ac 5 5 5 5 5 5
af 6 6 6 6 6 6

I do I make this happen in pivot table?

Jim Roth