Pivot table formatting problem

[ScubaBum via OfficeKB.com]

I created a pivot table that somehow interpreted one of my data points in two
different ways. In the table the value is shown as a left justified value and
a right justified value even though the source data is all General, Left
(Indent). So there are two of the same value in the drop down box for
selection in the table and I have to select both in order to include all data
points with this single value. I have completely recreated the table and I
have made sure that the source data format is the same for all occurences of
the data field and then refresh the table. Still shows the two versions of
the single value. This is driving me crazy because I cannot fathom why Excel
does this.

Thanks

 

[Debra Dalgleish]

If it's showing the same value twice, then they're different values in
the source data. Perhaps one value has space characters at the end, or
one is text and one is a date or number.

Instead of changing the format of the source data, copy the value from
one cell to all others with the same value. Then refresh the pivot
table, and only one instance of the value should remain.