Pivot Table renamed items "myItem" -> "myItem2". Why?

[tribulusterrestris]

Hi everyone,
this is my first post.

I have a table in excel like this:

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]State
[/TD]
[TD]City[/TD]
[/TR]
[TR]
[TD]NY[/TD]
[TD]New York[/TD]
[/TR]
[TR]
[TD]NY[/TD]
[TD]Albany[/TD]
[/TR]
[TR]
[TD]FL[/TD]
[TD]Miami[/TD]
[/TR]
[TR]
[TD]FL[/TD]
[TD]Tampa[/TD]
[/TR]
[TR]
[TD]Washington[/TD]
[TD]Seattle[/TD]
[/TR]
</tbody>[/TABLE]










Then I created a pivot table and played around, adding lines, changing values on the table. Etc.
The problem is, my pivot table now displays this:

[TABLE="class: outer_border, width: 500, align: left"]
<tbody>[TR]
[TD]NY
[/TD]
[TD]New York
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Albany
[/TD]
[/TR]
[TR]
[TD]FL
[/TD]
[TD]Miami2
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Tampa2
[/TD]
[/TR]
[TR]
[TD]Washington
[/TD]
[TD]Seattle
[/TD]
[/TR]
</tbody>[/TABLE]








If I remember well, I previously did a typo in FL, refreshed the pivot cache, corrected and then refreshed again. I'm only noticing this number 2 at the end now, so I'm not sure why or when it appeared.

Please excel gurus, help me on this.

Best regards.

 

[tribulusterrestris]

SOLVED:
1. Select Pivot Table
2. On the Ribbon go to Pivot Table Tools
3. Actions pane
4. Clear drop down menu
5. Clear all (pivot table will be reset)
6. Build again the pivot table, selecting the fields, applying formats, etc.

Maybe is just a workaround. I still don't figured out what caused or how to prevent.