complex data transposing

[nautilia]

Hi all,
I'm rearranging a table and I am blocked. Please, help me. I don't know if what I want it's possible to do in Excel.

I have a table with electoral results with this structure:

City	Party	Results
City 1	Party Z	30
City 1	Party Y	20
City 1	Party X	10
City 2	Party Y	40
City 2	Party Z	30
City 2	Party X	12
City 3	Party X	40
City 3	Party Z	10
City 3	Party Y	10

And what I want to get is this:

City	Party X	Party Y	Party Z
City 1	10	20	30
City 2	12	40	30
...	...	...	...

I have several problems I don't know how to resolve them.
Original results are ordered first by city and then by party. But the parties are not in the same alphabetical order for each city, but ordered according to its result (high to low).

What I want is only one row for each city, showing the results for each party. But the main problem I see is this different parties order for each city.

Any suggestion about how to proceed?

Thanks in anticipation!

Frans

[MarvinP]

Hi Frans and welcome to the forum.

This looks like you simply need to do a Pivot Table with your existing data. Use the City as Rows, Party as Columns and Result in the Values area.

[bentleybob]

I'd use SUMIFS. Piece of cake. Upload a small sample file if you want to see how this would work.

[MarvinP]

Hi Guys,

Here is the Pivot Table answer - Add your formulas and let's see the different ways of doing this problem.

[bentleybob]

Here's my version, using formulas.

[nautilia]

Pivot tables, yes!
Thank you MarvinP. I was very obfuscated, working with Google Refine and Excel. And the solution was so simple!
bentleybob, thank you for your suggestion too. For my case, pivot tables is a simpler solution.