•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
I'm confused about how to create a pivot table that analyzes answers from a drop down list.
Hi there. I'm working on analyzing ~ 2,000 survey responses for a qualitative research project. We tagged each response from a selection of 50 "tags" that marked themes we were spotting. We listed the 50 tags in a drop-down list.
How would I create a pivot table that analyzes the contents of a drop-down list? I have been learning pivot tables from the youtuber 'excelisfun' whom y'all mentioned here. This has been a great resource, but I'd appreciated any leads to a more targeted resource.
[link] [comments]
Want to read more?
Check out the full article on the original site