Made a pivot table to count unique values in a list of data - is there a way to combine unique values to count together in one row?

I have a list of names, and made a pivot table to count how often the names appear in the list. That I can do no problem.

However, some names are entered for formatted in different ways, for example John Doe vs John D. vs John -- will all count separately in different rows. Is there a way to maybe manually combine the rows into a single count? Without having to manually edit the data itself?