Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: pivot table data not consolidating

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    28
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi All,

    I have a pivot table that has a row field for each vendor and a column field for each month (Jan, Feb & March). The pivot table is showing one row for the March total and a second row for the Jan & Feb totals:

    Vendor......Jan.....Feb.....Mar
    Smith.......................300
    Smith.......100.....200........

    What I really want to see is one line for each vendor. I've adjusted everything I can think of, sort orders, etc. to no avail.

    Any suggestions?

    Thanks in advance,

    DavidH

  2. #2
    New Member
    Join Date
    Mar 2002
    Posts
    48
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Why don't you double check your data. Smith may inadvertantly have leading or trailing spaces or be spelled differently in Mar which would cause Excel to think they are different and put them on different lines

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    28
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks, it was a trailing space; thought I had checked that, but I missed.

    Thanks again for the help!

    David

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •