Perhaps some of the entries have space characters at the end, and others
don't.

Marian wrote:
In column A I have several of the same names listed more than once spelled
exactly the same but when these line are pulled into a pivot table each is
displayed seperately. I followed the same exact procedure for this table as
I have for the others that I displayed correctly. What causes those lines to
be displayed on separate lines?