I have data in rows like this:

Sally Bob Dave Wally
Jim Dave Henry Frank Ralph John Ringo George Paul
Henry Bob

There can be as many as 25 names and the number of rows will increase.

I am trying to get all the names in a separate column and remove duplicates.

I would gratefully appreciate help with this?