Doubles in PivotTable

Sometimes when you try to build a Pivot table, the filter shows that all data is unique, while the table presents this data as doubles.


The reason is very simple: some data in your cells have empty spaces at the end, and the Pivot table treats this as separate data, while the filter
thinks its the same. That’s the magic of Excel.
So remove the dashes, refresh your Pivot table and everything should be correct.

Leave a Comment