Need to Organize by Number of Times Value appears in a Column

I have a spreadsheet that I am having difficulty sorting. I have a number of usernames with associated information to them contained within their row of data. I am able to sort by username very easily.

What I need though is a way to organize the data in a different manner. I only need the usernames that have been logged multipule times to display, or be separated from those that only appear once.

If I can seperate the usernames that appear two or more times from those that only appear once

I would like to be able to sort by the number of times that the username repeats in the sheet. (i.e) Usernames that have appeard 5 times by alpha at the top followed by 4 ect. This would allow me to eliminate those that only appear once easily and allow me to work with the data I need.

If there is a way to organize the usernames by alpha, but keep those that have not appeared multiple times from displaying, that would be fine as well.

Here is essentially what I have now. The Usernames are sorted by Alpha

Line1: _UsernameA__Info__Info__Info
Line2: _UsernameB__Info__Info__Info
Line3: _UsernameB__Info__Info__Info
Line4: _UsernameC__Info__Info__Info
Line5: _UsernameD__Info__Info__Info
Line6: _UsernameE__Info__Info__Info
Line7: _UsernameE__Info__Info__Info

I need UsernameB and E separated, I can't do it manually, because I have thousands of lines of this, and a low percentage are repeat Usernames.

Ideally it would look either like this:

Line1: _UsernameB__Info__Info__Info
Line2: _UsernameB__Info__Info__Info
Line3: _UsernameE__Info__Info__Info
Line4: _UsernameE__Info__Info__Info

With the other data hidden or Like this.:


Line1: _UsernameB__Info__Info__Info
Line2: _UsernameB__Info__Info__Info
Line3: _UsernameE__Info__Info__Info
Line4: _UsernameE__Info__Info__Info
Line5: _UsernameA__Info__Info__Info
Line6: _UsernameC__Info__Info__Info
Line7: _UsernameD__Info__Info__Info

I know I've seen data organized in this manner before, I just need a way to do it. Any Help is greatly appreciated.