•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