what gbm said
I would first get a handle on
variations in metadata and normalize those.
In the Tag browser: select a section to work with:
OK, there are advantages and disadvantages to each of these.
Right click: rename, delete <<working in the Tag browser itself, you get to see what books are affected, simply by making the Red + appear
Right click: Manage << allows you to scroll and fix or delete, but you don't get to see what was affected while working
Each section works the same.
Caution with Series: Your library may have books with the same series names that are NOT in the same series. For those I chose to put the authors initials in paren as a tie breaker Series (AB)
BTW rename to an existing value will merge the tags