Help with segregating names in an excel sheet

I have an excel sheet with names and data associated with the names. Few names occur only once in the sheet and a few occur twice and few thrice. Is it possible to gather all the names based on the number of times it occurs in the document?

Appreciate your time and help

Thank you

Pivot Table

Without knowing the format of your data is there any reason why you can't use a Pivot Table for this?

Regards
Mark