If you want to do it manually I suggest sorting by column B and then
copy paste the list of names and then where you want them horizontal,
you would right click PASTE SPECIAL. Select Transpose.

No one likes manual work but it takes seconds to do.


--
Backdoor Cover
------------------------------------------------------------------------
Backdoor Cover's Profile: http://www.excelforum.com/member.php...o&userid=19842
View this thread: http://www.excelforum.com/showthread...hreadid=376068