For the problem as stated and the example data, I think you've got plenty of nice solutions. In particular, I think I like the one from moritz. However, before you use a solution which splits on spaces, are you really sure your example data is representative and that none of the names in your names field will ever contain a space?