Forum Discussion
Need help to merge multiple data sets and sum certain columns subject to other fields meeting criteria
I have a years worth of monthly submitted data (12 files total, individual files are large) and I want to aggregate rows subject to columns matching, summing one column. So if I had column a, b, c, d...
I've attached 2 sample excel files. PBI1 is the first month and PBI2 is the second.
Order of Operations
Group by column D (ReportingFacilityID) IF Column M (AcitivityID) and Column N (ProductID) are the same, sum Column O (Volume) in to one row.
Like this?
