Forcing pivot table not to group? RRS feed

  • Question

  • Hi.

    I hope this is a good section for this question.

    I am trying to create a pivot table in Excel and it works quite fine, but I don't know how to do one thing - stop Excel from strange grouping or somehow connect columns with values.

    I know it sounds shady, but here is a sample file showing what I get and what I want:


    I'll be very grateful for any help or at least an affirmation that it's not possible.



    Wednesday, December 8, 2010 4:12 PM


  • Hello Brovar,

    Thanks for posting. This is a forum for programmers. As far as I see, your question is more an end-user level question, not a developer (programming) question. You're more likely to find people knowledgeable in this area on the Answers/TechNet sites:

    Using Pivot Tables, Charts, and other ways to Display Information:
    Excel IT Pro Discussions:

    If you have any concern for this post, or I have mistaken this issue, just feel free to follow up. Have a nice day.

    Best regards,
    Bessie Zhao - MSFT
    MSDN Subscriber Support in Forum
    If you have any feedback of our support, please contact msdnmg@microsoft.com.

    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Thursday, December 9, 2010 6:01 AM