•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
Tagged with
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#financial modeling with spreadsheets
#Excel alternatives
#Pivot Table
#Excel
#Distinct Values
#Brand
#Report
#Formulas
#Data Analysis
#Rows
#Columns
#Aggregation
#RBL
#WOB
#RHO