I pasted html address data onto a new sheet, which worked perfectly. I
wish to relocate 60,000 records of data in columns to rows, IE:

From this format:

A
1 Name
2 Street
3 City
4 State
5 Zip

To this format:

A B C D E F
1 Name Street City State Zip Telephone

I have tried a Macro, but can't get it to replicate, and I have tried
using Move/Special Paste with Covert to Value, but it won't work on
text.

If I try to move all this data by hand, I could be at this for
months...

Help, please!!!

Thank you!


--
jawdawson
------------------------------------------------------------------------
jawdawson's Profile: http://www.excelforum.com/member.php...o&userid=30648
View this thread: http://www.excelforum.com/showthread...hreadid=503059