MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formatting a sheet

Posted by Rank on January 29, 2002 12:15 AM

I have a huge xl file with names and addresses in the following format:

123 brent view apt
Atlanta, GA
Ph : (xxx)xxx xxxx
Fx : (xxx)xxx xxxx
e-mail :
web :

I need to format the data in such a way that I have 1 record per

Name Address Phone Fax e-mail web
Jim xxxxx xxx xxx xxxx xxx

Could someone help. Thanks in advance.

Posted by Ivan F Moala on January 29, 2002 4:16 AM

Have a look @ Copy > PasteSpecial > Transpose.
You may need a macro to do the tediuos task ?


Posted by Rank on January 29, 2002 10:15 AM

Thanks Ivan, I wrote a macro and got the task done with. Damn, wished there could be something simpler. Take care.