I have a situation. I have three columns
| A | B | C | |Category | Sub | Price |
Column A is basically Category column, column B is Sub Category and "C" is price.
I need to add the prices in column C if the category names and sub categories names are Same. Data structure is like below:
|A |B | C | Cat A | Sub A | 100 Cat A | Sub A | 100 Cat A | Sub B | 100 Cat A | Sub A | 100 Cat B | Sub A | 100 Cat B | Sub B | 200 Cat B | Sub B | 100
So what I need to add the values for rows with similar A and B and make it one row.
For example, in Excel find all Cat A and Sub A and make one row, add all values of these:
Cat A | Sub A | 300 Cat A | Sub B | 100 Cat B | Sub B | 300
I used the 'consolidate' option, but it's only taking one left column, so it' not preserving the column B data if I choose the data based on column A.