Pivot Table not sorting correctly

[Guest]

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?

 

[Debra Dalgleish]

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