Combine rows that have the same zip - but some are long postal codes and others are short

Question

Hi, Completely noob here obviously, but I'm glad to be here and learning!

I know this will have a simple answer, but i'm not able to put together in my brain the way to do this.

I have two rows that each have a zip and revenue amount

1. 01040 $1000

2. 01040-2223 $2000

I want to sum this into one line

01040-2223 $3000

There could be any number of lines that have these zip codes, so my thinking is I need some sort of formula that says "If first 5 numbers match, then sum together"

I'm sure there is a very simple way to do this, but I haven't learned it yet :)

Thanks for the help

JamesCharnley · Accepted Answer

Hi @CNichols84,

This shouldn't be too difficult, but the exact answer will depend on which ZIP you want in your final output. Matching the first five as you said can be done with a formula and summarize, but the output will still be the first 5 for now. If you wanted the max length for example, we could do that but it would take more tools.

DataNath · Accepted Answer

This ought to work as long as there's no massive variation in your formats that you haven't mentioned in your post. Can keep/remove fields as you wish with a Select tool afterwards: