Group numbers by category

[garretwalters12]

How do I sum numbers by category. Instead of having two rows by the zip code of 35007, I  would like just one but with the total being for both lines. Total Sales should equal $405.85 and Total Tax Collected should equal $16.23.

[KOBoyle · Accepted solution]

You can the Transform:Summarize tool. For State and Zip, select Group By. For the numeric fields, select Sum.