•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Pivot table, count pairings across multiple columns
Any way to achieve the following?
I have two columns of people's names, call them Partner 1 (Column A) and Partner 2 (Column B). Example input:
| Partner 1 | Partner 2 |
|---|---|
| Jill | Adam |
| Adam | Jack |
| Jack | Jill |
| Jack | Adam |
| Name | Partners | Count |
|---|---|---|
| Adam | Jack | 2 |
| Jill | 1 | |
| Jack | Adam | 2 |
| Jill | 1 | |
| Jill | Adam | 1 |
| Jack | 1 |
The above table is the type of output I want.
There are other columns of the input data, but just simplifying for the sake of discussion.
Using standard pivot tables, I can only create two separate pivot tables of Column A person with Column B person and separately Column B person with Column A person. How do I combine the two columns together for a total pairing count?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#financial modeling with spreadsheets
#rows.com
#big data management in spreadsheets
#conversational data analysis
#Excel compatibility
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#Excel alternatives
#data analysis tools
#data cleaning solutions
#pivot table
#pairings
#count
#columns