Hey guys, I'm new here and hope someone can help. I am working on a payout sheet with thousands of rows that need to be consolidated. Example attached. The end result needed is as follows:
Each individual (column B) on this sheet is assigned an owner ID (column A). There is also a Parcel ID (column C) for each unique property, and then an amount owed (a new row for each month) to that individual for that property. These amounts are added to the sheet every month, accumulated for years. I was hoping that there is a way for me to consolidate this data in a way so that there is only one row for every combination of column A and C, and also SUM the amounts for the combined rows. I know there has to be an easier way other than manually copying and consolidating all of this into a new sheet which is what I was asked to do. Please see the example attached, columns G though J is what the end goal needs to be.
Bookmarks