+ Reply to Thread
Results 1 to 6 of 6

Pivot help : Repeat row field labels within pivot table

  1. #1
    Registered User
    Join Date
    07-02-2005
    Posts
    2

    Pivot help : Repeat row field labels within pivot table

    Hi all,

    I have a pivot table with 2 row headers, and the pivottable will not repeat the Class headings for each row , eg :

    Class Student Score
    A 1 90
    2 50
    B 1 90
    2 80

    Is it possible to have the pivottable output in the following manner instead :

    Class Student Score
    A 1 90
    A 2 50
    B 1 90
    B 2 80

    Thanks in advance for your assistance!

    Regards,
    Alvin

  2. #2
    Forum Expert
    Join Date
    12-24-2004
    Location
    Sweden
    Posts
    1,256
    See this: http://www.excelforum.com/showthread.php?t=378947
    HTH
    Ola

  3. #3
    Dave Peterson
    Guest

    Re: Pivot help : Repeat row field labels within pivot table

    You can't do this and maintain the pivottable.

    You could copy the pivottable to a new worksheet and convert it to values
    (edit|copy followed by edit|Paste special|Values) (or you could even just
    convert the pivottable itself to values).

    But after you do that, you can fill the blank cells by using one of the
    techniques at Debra Dalgleish's site:
    http://www.contextures.com/xlDataEntry02.html

    alvchua wrote:
    >
    > Hi all,
    >
    > I have a pivot table with 2 row headers, and the pivottable will not
    > repeat the Class headings for each row , eg :
    >
    > Class Student Score
    > A 1 90
    > 2 50
    > B 1 90
    > 2 80
    >
    > Is it possible to have the pivottable output in the following manner
    > instead :
    >
    > Class Student Score
    > A 1 90
    > A 2 50
    > B 1 90
    > B 2 80
    >
    > Thanks in advance for your assistance!
    >
    > Regards,
    > Alvin
    >
    > --
    > alvchua
    > ------------------------------------------------------------------------
    > alvchua's Profile: http://www.excelforum.com/member.php...o&userid=24867
    > View this thread: http://www.excelforum.com/showthread...hreadid=384081


    --

    Dave Peterson

  4. #4
    Registered User
    Join Date
    07-02-2005
    Posts
    2
    Dear Olasa and Dave,

    Thanks for your help, that's a great solution.

    If I remember correctly, this used to be an option in Excel 97, pity Microsoft removed that.

    Kind regards,
    Alvin

  5. #5
    Forum Expert
    Join Date
    12-24-2004
    Location
    Sweden
    Posts
    1,256
    Thanks for the feedback. Happy it helped
    Ola

  6. #6
    Debra Dalgleish
    Guest

    Re: Pivot help : Repeat row field labels within pivot table

    No, Excel 97 didn't have the option to repeat the labels either.

    alvchua wrote:
    > Dear Olasa and Dave,
    >
    > Thanks for your help, that's a great solution.
    >
    > If I remember correctly, this used to be an option in Excel 97, pity
    > Microsoft removed that.
    >
    > Kind regards,
    > Alvin
    >
    >



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


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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