I have always wanted a way of handling this at the Authors Level.
Andrew North -> Andre Norton
S. L. Viehl -> Lynn Viehl
And a ton the have middle names: Initials, full name, missing, nicknames (E. E. 'Doc' Smith)

inconsistent Metadata for the same person