•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Pivot table on distinct values
C2ould someone help me. I've been slowly tearing out my hair as I seem to be having some issues in setting up a pivot table that does the following.
I've done myself a report by formulas so it's not the end of the world, but still kinda wanna figure how to do it via pivot table for the future.
So I have the following table
| Person | ID | Brand | 29 | 30 | 1 | 2 |
|---|---|---|---|---|---|---|
| Person | P1 | Brand | WOB | WOB | WOB | WOB |
| Person 2 | P2 | Brand 5 | WOB | WOB | WOB | WOB |
| Person 3 | P3 | Brand 9 | RBL | RHO | RBL | RBL |
I want to end up with a pivot table that gives me something like
| - | 29 | 30 | 1 | 2 |
|---|---|---|---|---|
| RBL | 1 | 0 | 1 | 1 |
| WOB | 2 | 2 | 2 | 2 |
| RHO | 0 | 1 | 0 | 0 |
ETC
[link] [comments]
Want to read more?
Check out the full article on the original site