Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Forums » Excel Forums » Pivot Tables » Row Labels in excel 2007 Pivot Tables

Row Labels in excel 2007 Pivot Tables

Previous | Next
Latest post Sun, Nov 23 2008 3:13 AM by Nick Hodge. 1 replies.

  • Sun, Nov 23 2008 12:32 AM

    • Edward
    • Top 500 Contributor
    • Joined on Sun, Nov 23 2008
    • Posts 1
    • Points 21

    Row Labels in excel 2007 Pivot Tables

    Reply |Contact

    Hi,

            I'm creating a pivot table and in column A I have row labels but when I have row labels in columns A & B column A only shows the label on each new occurance of a new label and I need to have the label (data) to appear for each line. Any suggestions

    Thanks

    Ed
    Filed under:
    • Post Points: 21

  • Sun, Nov 23 2008 3:13 AM In reply to

    • Nick Hodge
    • Top 10 Contributor
    • Joined on Sun, Dec 23 2007
    • Southampton
    • Posts 336
    • Points 5,771
    • MVP

    Re: Row Labels in excel 2007 Pivot Tables

    Reply |Contact |Mark as Answer

    Ed

    Are you needing this because you want a formula against each row label? I normally handle this by taking the resulting pivot table and copying the data only to another sheet and then running some VBA over the row labels to fill the gaps.

    I have asked for some time for a setting to do this, but it is slow coming Sad

    Regards
    Nick Hodge
    Microsoft MVP, Excel
    Southampton, UK
    Filed under:
    • Post Points: 5
Page 1 of 1 (2 items) | RSS
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.