This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.