Data with the same horizontal axis label not autosumming in a pie chart

Hello,

I am looking to get my chart to add data with the same horizontal access label and put it into one pie slice.

Here is a picture of what I'm looking at

http://postimg.org/image/4jq3k2l79/

For example, as you can see at the bottom, there are three slices of the pie marked 602 that I thought would be combined into one bigger slice.

I'm unsure how to enact this functionality so any ideas would be great.

The workbook is here

http://www.filedropper.com/chartproblem

To preempt someone saying that I could just add them up manually, I want to create a macro doing this work for me so the reference would have to be dynamic. The easiest way in my head to do this would be to do what I described above, though I could be wrong.

Any help is appreciated.

Edit:
Yes, I have considered Pivot tables. Since the input is standardized though I wanted to be able to just hit a button and have all the pieces all into place. If I could do that with pivot tables too though I wouldn't mind doing that as well.