Hi All,
I am trying to build a pivot table that collates results from customer surveys. In these customer surveys, customers are asked their favorite things/attributes of our product, a hotel, and can respond with multiple answers e.g. "design," "price", "location". Some people respond with just one thing, others respond with up to five attributes. We collect these results and manually put them into an excel sheet for retention and analysis. To help me identify the things our customers like best about our product and to track this dynamically over time, I would like to create a single pivot table that collates these results. As such, I have been getting our data input team to enter each response with each attribute in its own column. However, when I try to collate the data into a single table, I am not able to work out a way for the table to show a single row identical responses/attributes e.g. "design" or "location", when those responses are in different columns. My question for the forum is whether this is even possible?
Attached is a brief example of what I am working with. You can see that "design" is a very common answer - it accounts for 14 of the 40 answers. However, when I try to create a Pivot table, I am not able to generate a single table with a single row labelled 'design' that shows a count of 14 but also shows attributes that do not appear in the first column e.g. "amenities" or "furnished"
Any help would be greatly appreciated!
Jonathan
Bookmarks