+ Reply to Thread
Results 1 to 2 of 2

Designing Pivot table that returns results for multiple columns with identical data

  1. #1
    Registered User
    Join Date
    10-28-2019
    Location
    Hong Kong
    MS-Off Ver
    2016
    Posts
    1

    Designing Pivot table that returns results for multiple columns with identical data

    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
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    396

    Re: Designing Pivot table that returns results for multiple columns with identical data

    Hello,
    Try it can reorganize your data. My proposal is attached.
    Regards
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pivot Table - Multiple Data Columns issue
    By robertgardner1994 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-13-2019, 06:04 AM
  2. [SOLVED] Identical Formulas from Identical Data Sets Return Different Results
    By EverClever in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-28-2018, 06:56 PM
  3. Adding Multiple Identical tables to a Master Identical table
    By dlogfx in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-24-2017, 04:41 PM
  4. Replies: 1
    Last Post: 06-20-2012, 08:14 AM
  5. Pivot table from multiple columns of data vs date
    By Dfarland in forum Excel General
    Replies: 2
    Last Post: 07-05-2011, 06:22 PM
  6. designing and saving predefined pivot table formats?
    By Surfstiling in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-25-2005, 12:06 AM
  7. [SOLVED] How to have multiple columns in pivot table data area?
    By mitch1962 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-24-2005, 06:07 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1