Compare 2 columns and sum frequency of duplicates

Now I put more data. But now I want to sort who has more users under its name. Like the first one into the 4th and last pivottable Grant Rodgers he has only one user under his name... while Grady Payne has 3. So I want to filter in order to put Grady Payne and other like him (1+ users under his name). I made some attempts using filter but with no success...

Sorry, Sample2 is the correct one