split column based on different delimiters

Logically Anonymous how would you propose doing this?

You cannot use commas as the delimiter because that sometimes splits the names, not just groups of names.
You cannot use spaces as the delimiter because someone could have a space in their name - Jones, Mary Ann for example.

You cannot count spaces or commas because the data is inconsistent.

If you can come up with logic that will work, then we can help. Text.BeforeDelimiters(), Text.AfterDelimiters(), and Text.BetweenDelimiters() will likely be the most useful here, but without having some sort of logical consistency to work with, it is going to be difficult to make this work.