Hello team,
I'm trying to consolidate or summarize duplicate values, but not sure how to get this.
This is my original dataset:
| Employee | Store | District | Count |
| 1 | A | a | 35 |
| 2 | A | a | 30 |
| 3 | A | a | 22 |
| 1 | B | b | 20 |
| 1 | C | c | 21 |
| 2 | B | b | 21 |
| 2 | B | b | 18 |
| 3 | B | b | 15 |
| 2 | C | c | 12 |
| 3 | C | c | 10 |
I want to output the following:
| Employee | Store | District | Count |
| 1 | A | a | 76 |
| 2 | A | a | 81 |
| 3 | A | a | 47 |
Solved! Go to Solution.
@Isabroks The following settings in the summarize tool should work
It worked!! Thanks :D
