Having another problem.

How can I set up a function to transpose vertically placed text data
horizontally automatically without doing so manually. I have a very
long list of contact information that is formatted as five vertical
cells per contact a blank cell and then the pattern continues. Any
help? I am desperate!


--
EMCUE
------------------------------------------------------------------------
EMCUE's Profile: http://www.excelforum.com/member.php...o&userid=32945
View this thread: http://www.excelforum.com/showthread...hreadid=531115