• Repeat Item Labels in Pivot Tables Excel 2007

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Repeat Item Labels in Pivot Tables Excel 2007

    Author
    Topic
    WSMyers515
    AskWoody Lounger
    October 6, 2010 at 12:58 pm #472137

    There is a new option in Excel 2010 pivot tables which allows item labels to be repeated in columns. Is there a way to do this in Excel 2007?

    Reply | Quote
    Viewing 4 reply threads
    Author
    Replies
    • WSrory
      AskWoody Lounger
      October 7, 2010 at 6:40 am #1248302

      Not with a live pivot table, no. You have to copy and Paste special-values, then fill in the gaps.

      Reply | Quote
    • WSMyers515
      AskWoody Lounger
      October 7, 2010 at 11:19 am #1248399

      Thanks Rory, I hadn’t found a way to do it, but thought I would just throw it out there in case I was missing something. Thanks for your time.

      Reply | Quote
    • Tim Sullivan
      Member
      October 7, 2010 at 6:27 pm #1248498
      Reply | Quote
    • WSMyers515
      AskWoody Lounger
      October 8, 2010 at 6:38 am #1248557

      Thanks Tim, unfortunately I still have Excel 2007 and the new Repeat Item Label function is Excel 2010.
      I overcome the no Repeat Label problem by adding an ID column of line numbers to my data and then making that the left-most label in my pivot. Just thought I’d see if anyone had a less time-consuming way of overcoming this lack of feature in Excel 2007.
      Thanks again.
      Meleia

      Reply | Quote
      • WSslobmeat
        AskWoody Lounger
        September 17, 2012 at 7:33 pm #1349355

        Bit old, but I just ran into this problem because my office still has Office 2003. What rory said, but here’s my formula to help fill in the gaps.

        1) Create a new column to the left of the one you want to fill in – let’s call this column A, and the original one B
        2) Copy B1 into A1
        3) A2 = if(B2=””,A1,B2)
        4) Fill Down

        So, if column B has a value, it copies it into A, else it copies the entry above the current cell in A – that’s why we primed it with step 2.

        31981-Example

        Reply | Quote
    • WSrory
      AskWoody Lounger
      September 18, 2012 at 2:58 am #1349369

      You can also:
      -Select the row fields
      -Press f5
      -Choose Special… then blanks
      -type = then press the up arrow then press Ctrl+Enter.
      -Finally copy and paste special – values if required.

      Reply | Quote
    Viewing 4 reply threads
    Reply To: Repeat Item Labels in Pivot Tables Excel 2007

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    June 2025
    S M T W T F S
    1234567
    891011121314
    15161718192021
    22232425262728
    2930  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.