How to convert one column to a row

[x2005]

Hi,

I have a table like this:

Person1 Province1 10
Person1 Province2 10
Person1 Province3 10
Person2 Province1 10
Person2 Province2 10
Person2 Province3 10

want to convert it to:
EMPTY province1 province2 province3
person1 10 10 10
person2 10 10 10

Thanks!

[NBVC]

Say the upper table is in A1:C10

And the second table top left corner EMPTY cell is in D1, then in E2:

=SUMIFS($C$1:$C$10,$A$1:$A$10,$D2,$B$1:$B$10,E$1)

copied down and across.

[x2005]

Sorry. Maybe I didn't make it clear here. I'm not trying to get the SUM. I just want to re-organize the table format.

Person1 Province1 1
Person1 Province2 2
Person1 Province3 3
Person2 Province1 4
Person2 Province2 5
Person2 Province3 6

want to convert it to:
TITLE province1 province2 province3
person1 1 2 3
person2 4 5 6

Thanks!

[NBVC]

as long as there is only one unique combination of Person/Province, the sum is the sum of one number only, the matching one

[x2005]

got it! thanks a lot!!