tribulusterrestris
New Member
- Joined
- Mar 5, 2015
- Messages
- 7
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.
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.