Hi I need a code that would consolidate data that have the same non-amount values. To illustrate:
A B C
X Y 10
X Y 15
G H 12
G H 5
D S 3
Would then be consolidated as:
A B C
X Y 25
G H 17
D S 3
The original file would have hundreds of columna and thousands of rows.
Thanks in advance!
A B C
X Y 10
X Y 15
G H 12
G H 5
D S 3
Would then be consolidated as:
A B C
X Y 25
G H 17
D S 3
The original file would have hundreds of columna and thousands of rows.
Thanks in advance!