+ Reply to Thread
Results 1 to 3 of 3

Pivot Table Appending an unnecessary '2' to a list of names

  1. #1
    Registered User
    Join Date
    09-06-2021
    Location
    Mackay, Australia
    MS-Off Ver
    Office 365
    Posts
    7

    Pivot Table Appending an unnecessary '2' to a list of names

    I have a very simple list of names, only 17 entries long, and among that list is the name Etienne. When I tried to make a pivot table to list these names in another sheet (to help with functions in some cells), every name appears just fine, except Etienne, who appears as Etienne2. Any misspelling of the name will make it appear just fine in the pivot table (spelling error and all), but any entry of the name Etienne messes it up. I even tried using the name Etienne2 in the list, and the pivot table gave me Etienne22, which isn't very relevant to anything, but kind of annoying.

    Why is the pivot table appending a number to the end of this name, and how can I fix this? (there are no duplicate names, so my easiest theory is unfortunately shot)

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Pivot Table Appending an unnecessary '2' to a list of names

    Hi Larz,

    I'd be looking at the cell that has "Etienne" in it. What is the length of these? Are you sure the length of these strings is 7? What if you had them all as Etienne2 and the 2 was the same font as the background?

    Just a few things to try.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,440

    Re: Pivot Table Appending an unnecessary '2' to a list of names

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 01-28-2021, 11:48 AM
  2. Pivot Table - Calculated Item adds unnecessary rows
    By elderwand in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-10-2020, 12:14 PM
  3. Automating Pivot table and pivot chart creation if data table names unknown
    By Vegiepie2016 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-04-2016, 11:52 AM
  4. From A Table Of Names And Birth Dates Pull A List Of Names As Of A Reference Date And Ther
    By rahuleyes in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 17
    Last Post: 11-27-2014, 03:44 PM
  5. Show query column names behind pivot table field names
    By gbritton in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-18-2013, 03:17 PM
  6. [SOLVED] Search a list of names and automatically return any names not already included in table
    By bishbash89 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-21-2013, 09:06 AM
  7. [SOLVED] Return Names From List w/o Advanced Filter or Pivot Table?
    By d_striker in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 12-28-2012, 08:02 PM

Tags for this Thread

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