Combining fields with same data

jrgreen

Here is my current situation. I have two excel documents, both formatted the exact same. One document is for 2017 and the other is for 2018. These documents list the Year, Month, Account number, Subdivision number, Division Number, Amount (in dollars), and the Account Description.

I am wanting to cut out the subdivision and look solely at the division level. Since these documents list the subdivision, each subdivision may have a balance in the Account description. So after removing the subdivision, via a select tool, there will be duplicates of the one account for the same division. I need to then combine all of the amounts for the same account for each division. What I have in mind will look something like this.

I am needing the top to look like the bottom.

Edit: The subdivisions for accounts 888 are supposed to be different. My apologies.

itestu

Hi,

To combine your data, use a Union tool.

To get rid of the subdivision, I guess you can just use the Summarize tool to group your data by summing the amount grouped by Year, Month, Account number and Division Number. 

Irene