This is driving me crazy:
I have a table of text data and the first column has equipment numbers. All are collated on the Pivot table correctly except one "PS4". I have deleted the data, pasted as values, typed manually, formatted etc. but I still get the following result on the Pivot:
Data Table:
PS4
Pivot Table:
lkkkl;;;'lll
I thought someone in Microsoft was trying to mess with anyone using a Sony PS4 so I created a bank document and the Pivot works fine with PS4 in the data table, I'm lost. All help appreciated.
When I add a space in the equipment number to "PS 4" it works fine, see pivot screenshot attached.
Added Excel file, I had to remove most of the data for confidentiality reasons but hopefully, this works to show the error.
Bookmarks