Results 1 to 2 of 2

Pivot table noob in need of guidance

Threaded View

  1. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: Pivot table noob in need of guidance

    You need to restructure your data to get the After layout.

    The data should be 3 fields.
    ID|Question|Answer

    I also added the answers to the Custom Lists in order to get the order, which would usually be alphabetical.


    If you stick with your original layout you can see 1 question at a time.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to filter and clean the pivot table in excel?
    By kasen in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-24-2020, 12:26 PM
  2. [SOLVED] VBA create pivot table in excel 2010 defaulted to 2003 pivot table format
    By lynnsong986 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-15-2019, 02:05 PM
  3. Replies: 6
    Last Post: 01-24-2017, 06:56 PM
  4. [SOLVED] pivot table not listing things in one row
    By COLTS12OG in forum Excel Charting & Pivots
    Replies: 43
    Last Post: 01-29-2013, 06:35 PM
  5. Replies: 2
    Last Post: 07-19-2012, 05:07 AM
  6. [SOLVED] Create Pivot Table: Cannot Open Pivot Table Source File
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 01-05-2010, 05:11 AM
  7. how to delete/clean out the row list in pivot table
    By john² in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-26-2005, 05:15 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