Pivot Table from data table (not data LIST)

Discussion in 'Excel Charting' started by absolin, Dec 13, 2003.

  1. absolin

    absolin Guest

    What are some good ways to create pivot tables when your source data is
    in a table format, not a list format?

    For example, how would you create a pivot table from a calendar, which
    only has days' names at the top of the table, and has numerical dates
    in each cell (ie a Regular calendar :)

    The standard way would be to create a list of numerical dates, then add
    a column and type in "Monday" for each date that is a Monday, "Tuesday"
    for each Tuesday, etc.
    absolin, Dec 13, 2003
    1. Advertisements

  2. absolin

    Tushar Mehta Guest

    As far as I know, the PT requires the data to be in a form compatible
    with the prerequiste for a relational database model. What you
    describe is not an acceptable format.


    Tushar Mehta, MS MVP -- Excel
    Excel, PowerPoint, and VBA add-ins, tutorials
    Custom MS Office productivity solutions
    Tushar Mehta, Dec 13, 2003
    1. Advertisements

  3. absolin

    ychu Guest

    So now the question is that is there an easier way to convert table to
    list? And then we can feed it into a pivot table.
    ychu, Jan 2, 2004
  4. Debra Dalgleish, Jan 2, 2004
  5. absolin

    Sam Guest


    I followed this link, but I couldn't find the "Multiple consolidation ranges option" in Excel 2010? What's the best way of unpivot in Excel 2010?

    Sam, Jan 28, 2013
  6. Hi Sam

    To call up the Pivot Table & Pivot Chart Wizard in Excel 2010: ALT + D
    Alternatively add it to the QAT: More commands > All Commands > Pivo
    Table & Pivot Chart Wizard > Add.

    1: Tick the Multiple consolidation ranges > Next > Create a single pag
    field for me > Next > Select your data > Finish.

    2: Then double click the Grand Total cell.

    Kevin@Radstock, Jan 28, 2013
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.