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