X email

I have a list of e-mails that I extracted from MySQL as something like this: name@example.com firstname lastname name2@example.com firstname2 lastname2 name3@example.com firstname3 lastname3 and I want them to be in this format: firstname lastname firsntame2 lastname2 firstname3 lastname3 Using VIM, I can do: :% s/^/ / :% s/()s(w*)s(.*$)/2 3 1/ The last one is a bit more complex but uses the n-style references to parenthesed elements in the matching part.