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'd like to have all the column titles from other fields come over as well. Location, Operator, etc. I can't tell if it looks like it worked or not as it is very blurry. Apologies.
You can either group, or have all columns. Not both.
