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:

Jim
123 brent view apt
Atlanta, GA
Ph : (xxx)xxx xxxx
Fx : (xxx)xxx xxxx
e-mail : jim@jim.com
web : http://www.jim.com

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

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

Could someone help. Thanks in advance.
Rank.


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 ?

Ivan

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.