Hi, thank you in advance for the help. Here is my question:
I have a long list of contact information (name, email, phone numbe
etc.) I have to copy this information from a table that is organize
vertically like so...

Column 1 Column 2

Name Brian
Phone (123) 456-7890
Fax (123) 456-7891
Email

Name Carl
Phone 2343214
Fax 1234513
Email


What I need to do is organize this information into columns like so...

Name phone Fax
Email

Brian 2341234 1234134
Brian@
carl 43524 2435234
Carl@


I have been using the paste special and transpose function, but thi
process is very tedious for the long list that I have to do. The tabl
that I am copying from is organized in such a way that I have to cop
the labels in Column 1 along with the information in column 2. So i
order to use paste special I have to copy both columns, and paste bot
columns into excel. Then I have to delete Column 1 then re-copy jus
column 2, then paste special and transpose (does this sound lik
something you want to be doing 1000 times?). There must be an easie
way, but I just don't know it.

Maybe there is a formula that I can use to automate this process. Ca
anybody help me out with this? I am open to any suggestions. Thank yo
very much for your help.

Wil

--
wstaylor8
-----------------------------------------------------------------------
wstaylor81's Profile: http://www.excelforum.com/member.php...fo&userid=2949
View this thread: http://www.excelforum.com/showthread.php?threadid=49193