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
    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.

    --
    Regards,

    Tushar Mehta, MS MVP -- Excel
    www.tushar-mehta.com
    Excel, PowerPoint, and VBA add-ins, tutorials
    Custom MS Office productivity solutions

    In article <>,
    says...
    > 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.
    >
    >
    > ---
    >
    >
    >
     
    Tushar Mehta, Dec 13, 2003
    #2
    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
    #3
  4. To restructure your data, you may be able to use the "unpivot' technique
    described by John Walkenbach:
    http://j-walk.com/ss/excel/usertips/tip068.htm


    ychu < wrote:
    > 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.



    --
    Debra Dalgleish
     
    Debra Dalgleish, Jan 2, 2004
    #4
  5. absolin

    Sam Guest

    On Saturday, January 3, 2004 8:31:11 AM UTC+11, Debra Dalgleish wrote:
    > To restructure your data, you may be able to use the "unpivot' technique
    > described by John Walkenbach:
    > http://j-walk.com/ss/excel/usertips/tip068.htm
    >
    >
    > ychu < wrote:
    > > 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.

    >
    >
    > --
    > Debra Dalgleish


    Hi,

    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?

    Thanks
    Sam
     
    Sam, Jan 28, 2013
    #5
  6. Hi Sam

    To call up the Pivot Table & Pivot Chart Wizard in Excel 2010: ALT + D
    P
    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


    Sam;1608946 Wrote:
    > On Saturday, January 3, 2004 8:31:11 AM UTC+11, Debra Dalgleish wrote:-
    > > To restructure your data, you may be able to use the "unpivot

    > technique
    > > described by John Walkenbach:
    > > http://j-walk.com/ss/excel/usertips/tip068.htm
    > >
    > >
    > > ychu < wrote:-
    > > > So now the question is that is there an easier way to convert tabl

    > to
    > > > list? And then we can feed it into a pivot table.-

    > >
    > >
    > > --
    > > Debra Dalgleish
    > > Excel FAQ, Tips & Book List
    > > http://www.contextures.com/tiptech.html-

    >
    > Hi,
    >
    > I followed this link, but I couldn't find the "Multiple consolidatio
    > ranges option" in Excel 2010? What's the best way of unpivot in Exce
    > 2010?
    >
    > Thanks
    > Sa



    --
    Kevin@Radstock
     
    Kevin@Radstock, Jan 28, 2013
    #6
    1. Advertisements

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.
Similar Threads
  1. Vilok Kusumakar
    Replies:
    1
    Views:
    266
    Tushar Mehta
    Feb 17, 2004
  2. ludovic
    Replies:
    3
    Views:
    138
    Jon Peltier
    Sep 30, 2004
  3. Barb Reinhardt
    Replies:
    0
    Views:
    138
    Barb Reinhardt
    Dec 16, 2004
  4. coal_miner

    Exclude pivot table data from pivot chart?

    coal_miner, Jun 7, 2005, in forum: Excel Charting
    Replies:
    4
    Views:
    182
    Ed Ferrero
    Apr 17, 2007
  5. Missy

    Data Area of Pivot Table and Pivot Charts

    Missy, Apr 12, 2006, in forum: Excel Charting
    Replies:
    2
    Views:
    140
    Debra Dalgleish
    Apr 13, 2006
  6. Daniel
    Replies:
    1
    Views:
    210
    Jon Peltier
    Jul 31, 2007
  7. Grover
    Replies:
    4
    Views:
    241
    ShaneDevenshire
    Sep 28, 2007
  8. ls
    Replies:
    3
    Views:
    1,093
    David Biddulph
    Jul 14, 2009
Loading...