I am having a problem with my pivot table. I am trying to count a series of
words that reoccur in both the upper and lower case. However, instead of
grouping them together as one total, it splits them into two groups. For
example:

Here 58
here 3
They 45
they 23

I would like the table to recognize that a word in both the upper and lower
case are the same word. Is there a way?