+ Reply to Thread
Results 1 to 3 of 3

Pivot table creates extra data in fields

  1. #1
    Registered User
    Join Date
    06-17-2009
    Location
    Connecticut
    MS-Off Ver
    Excel 2007
    Posts
    7

    Question Pivot table creates extra data in fields

    I'm trying to create a pivot table, but there is a problem. Although my data only has 2 years (1996 and 1997), it creates a new year it calls "blank," and a lot of the data that is supposed to be under 1996 and 1997 appears under this "blank" year. How do I fix this?

    See the attachments for the data and pivot table.
    Attached Images Attached Images
    Last edited by Michael.H.; 06-18-2009 at 11:59 AM. Reason: Bad title and solved

  2. #2
    Forum Contributor mubashir aziz's Avatar
    Join Date
    03-18-2009
    Location
    Lahore, Pakistan
    MS-Off Ver
    MS Office 2013
    Posts
    533

    Re: Pivot table creates extra data in fields

    Its always better to attach sample file.

    Anyway, actually you must write 1996 in each cell From A2 to A13
    And 1997 from A14 to A25
    Now Pivot Table will give you exact figures .....
    If this post helps, Please don't 4get to click the star icon located at the bottom left of my Post.

  3. #3
    Registered User
    Join Date
    06-17-2009
    Location
    Connecticut
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Pivot table creates extra data in fields

    Thanks a lot. That really helped.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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