I’ve got a large amount of data and I need to consolidate unique rows based on 3 columns and then sum the value in a fourth. the problem is excel can only look at one column at a time to consolidate duplicates. the source data looks similar to this.
a|b|c|10 a|b|c|20 z|x|c|15 z|x|c|10
and I need it to look like this