+ Reply to Thread
Results 1 to 2 of 2

Pivot Table: Columns not selectable as fields

  1. #1
    Registered User
    Join Date
    09-15-2009
    Location
    San Francisco, Bay Area
    MS-Off Ver
    Excel 2003
    Posts
    1

    Pivot Table: Columns not selectable as fields

    Good Afternoon All,

    I'm using a spreadsheet I made in Excel 2007 to create a Pivot Table, but I'm running into problems when trying to find/select the proper fields.

    Here is how my spreadsheet is formatted:

    --------(Column A)----------(Column B)-------------(Column C)--------
    (sub a)(sub a)(sub a)(sub b)(sub b)(sub b)(sub c)(sub c) (sub c)


    As you can see, I'm using larger, merged Columns and individual sub sections. This helps me organize the spreadsheet better, but when trying to run a pivot table only the sub sections appear as selectable fields.

    How do I find and add the larger columns to my pivot table's list of selectable fields?

    Please, if I can provide anymore information to help clarify what my issue is, let me know, because the way I'm explaining my issue is a bit confusing. Thanks for your time and have a blessed day!

    -Oaki
    Last edited by Oaki; 09-15-2009 at 03:32 PM.

  2. #2
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561

    Re: Pivot Table: Columns not selectable as fields

    In an unhelpful way: your data is organised wrong; pivot tables consolidate lists into tables, by which I mean:

    list looks like:
    Please Login or Register  to view this content.
    table looks like
    Please Login or Register  to view this content.
    ^ this does not pivot easily

    More usefully, you can select the option to consolidate multiple ranges when creating a pivot table (in first window). It's not terribly simple, but if you're comfortable with pivots you should be able to pick it up.

    Google for more help, too long to write out instructions.

    HTH

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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