Why does same data value appear twice in rows of a Pivot Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

1. I have a field named "City" in my base data, that is captured on Rows of a
dependant Pivot Table.
2. In some rows of the base data (say about 500 rows of data out of 1000
rows), one data value in City field was wrongly entered.
3. The correct entry should have been "New Delhi" - but it was entered
erroneously as "Delhi" in some cells and "New Delhi" in others.
4. So when the Pivot Table was first created, it gave data categorized as
under City "New Delhi" as well as "Delhi", whereas it should have been "New
Delhi" only.
5. Later, I corrected the wrong entries of "Delhi" to "New Delhi". I also
refreshed Pivot Table.
6. Even after refreshing, the Pivot Table still does not show all data under
one data value of City "New Delhi". It now shows 2 separate entries for the
same City "New Delhi".
 
It sounds like there is a trailing space after some of the entries, or
perhaps a double space in the middle.
Try using the LEN function see if both versions have the same number of
characters.

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
 
Back
Top