Pivot table segregation issue

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

I have data in lists and I am having intermitant problems
with my pivot table differenciating on somehting I can not
see.

When I do a filter on a list I get no problems. But whne I
do a pivot table on the same data it sometimes splits it
up.

For example I might have 12 cells in a column with "#2BR"
in them.

10 will be in one pivot table group and then for no
visable reason I get 2 of the 12 in to another group

visually they look the same.

whats up.

thanks todd
 
Thanks anyway but I found the problem I think!

Apparently there is some unvisible to the eye leading and
trailing spaces that I removed with asap utilities

T
 
Back
Top