Pivot Table not sorting correctly

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?

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?