Pivot table insertion changes upper and lower case letters

[Jenn]

I am inserting a pivot table that has data that is case sensitive. There are
several instances of account ids that are identical to each other except for
the case of the letters. The data is correct and the case is correct there,
but when I insert the pivot table, the case for all of the identical ids
becomes the same on the table. How do I fix this? I have tried ensuring that
the cells are all in text format on both the data and the pivot table and
refreshed. Any help would be greatly appreciated.

 

[Shane Devenshire]

Hi,

Excel's pivot tables are not case sensitive. the only thing I can think to
do is to type thing that are capitals with a space after them and others
without the space. The pivot table sees the space.

 

[Jenn]

Hi Shane,

Thanks for the reply. The problem is that each of the cells may have some
upper and some lowercase letters. It seems that when there is an instance of
the same sequence of letters and numbers repeated with different cases in
each, it picks one and makes them all identical.

For instance the data has the following:

0013000000COGim
0013000000COgim
0013000000COgiM

The pivot table makes them all:

0013000000COGim

I need to keep the case sensitivity. I don't understand why it isn't copying
exactly what is in the cell that the data is coming from.

Thanks,

Jenn

 

[Shane Devenshire]

Hi,

As I pointed out in my last response, the Pivot Table is not case sensitive
and there is nothing we can do to change that. Your best bet is to make the
two entries different by adding on or more spaces, or you could enter the
entries with (1) at the end. Of course that is rather unlikely to be
acceptable in your case.