Transpose List

Hi Guys,

I posted this in the General Forum, but apparently it requires a VBA solution so I thought I'd bring it up here. The original thread is here:

http://www.excelforum.com/showthread.php?t=649537

Basically, I have a list of several thousand names, which needs formatting in the way shown in the attachment. I will be eternally grateful for any help/ideas.

...the elusive attachment