Are all the names in different cells?

RBS


"NigelVII" wrote in message
...
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?