Excel Pivot Table Appends a '2' to the field data items

[SunshineX]

My pivot tables work great but sometimes when I update them the field data entries are appended with a '2'

For instance a list of locations might contain the entry "Houston2" but the original data for that was just "Houston"

After remaking the pivot table and putting the exact same setup for it, it work fine again....for a while..

Why is this happening to me !? HELP!!

 

[SunshineX]

1: Do you ever alter the data in the pivottable itself?
2: do you do any drag and drop movements to sort the pivottable ?
3: Do you rename any fields or indeed any ITEMS in any fields ?
Rgds, Geoff

I have noticed that I cannot rename the "Houston2" in the pivot table itself. But I never alter the data in the pivot table, it happens when I click the update data Exclamation mark thing.

 

[Gavona]

All I want is to have it look at a column from the report, and tell me a list of every 'Location' that's in that column"

There is another way of getting a list of all the values in a particular column. Use Advanced Filter:

Name the range for your source data "database"
On the sheet where you want the list create a single cell with the value "location". Name this single cell range "extract"
With this sheet active Data, Filter, AdvancedFilter
Just leave the Criteria blank.

Doesn't explain your mystery about a 2 being appended to some data. If you get both Houston and Houston2 in the same table then I would explore the data. Maybe some entries contain a weird non-printing character (though I can't replicate your issue).

Thanks,

Gavin