Results 1 to 3 of 3

Having trouble trying to cross-tabulate multi-response question for pivot table

Threaded View

  1. #1
    Registered User
    Join Date
    11-28-2016
    Location
    Singapore
    MS-Off Ver
    2010
    Posts
    2

    Having trouble trying to cross-tabulate multi-response question for pivot table

    Dear all,

    I am encountering problems in cross-tabulating multi-response question for pivot table.

    Capture.PNG

    For example, in this table, one of the question is on "How do you deal with stress?", and there are multiple responses ranging from column D to K, but I am unable to get all the data to be used in the pivot table. The pivot table only accepts data for column D, excluding the rest until column K. Is there any other way to represent the data so that the pivot table is able to capture everything?

    Attached below is the excel file containing data that I am trying to cross-tabulated.

    Thank you for your help in advance!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Cross tabbing in a pivot table
    By Revphlak in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-16-2013, 07:39 AM
  2. [SOLVED] creating a Pivot Table out of data in a cross-tab tableau
    By icestationzbra in forum Excel General
    Replies: 2
    Last Post: 10-21-2012, 11:25 PM
  3. Values on first row of multi row pivot table
    By jorad in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-05-2012, 07:31 AM
  4. Tabulate data counts from pivot table
    By pphg in forum Excel General
    Replies: 0
    Last Post: 06-24-2012, 11:46 PM
  5. Pivot table using multi-value column
    By inomata in forum Excel General
    Replies: 1
    Last Post: 09-30-2010, 03:46 AM
  6. Trouble Using Pivot Table off a DNR
    By Research RN in forum Excel General
    Replies: 7
    Last Post: 01-09-2009, 12:03 PM
  7. Manual Cross Tabulation - Pivot Table Question
    By ktfish14 in forum Excel General
    Replies: 1
    Last Post: 03-05-2008, 06:50 AM
  8. Replies: 2
    Last Post: 04-17-2005, 03:06 PM

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