•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
Tagged with
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#machine learning in spreadsheet applications
#generative AI for data analysis
#Excel compatibility
#pivot table
#analyze
#drop-down list
#survey responses
#qualitative research
#Excel
#tags
#themes
#analysis
#resources
#data analysis
#youtuber
#Excel resources
#qualitative data