1 min readfrom 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.

submitted by /u/Remarkable_Turn_2034
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article