Question
June 20, 2007 at 01:42 PM
scottray76

Paste special transpose

by scottray76 . Updated 19 years, 4 months ago

I have a list of about 11,000 people that are in this format in excel:

John Doe
1234 Mountain Avenue
Park City, Utah 98765

and need to be in a spread sheet in this format:
John Doe 1234 Mountain Avenue Park City, Utah 98765.

In other words, instead of the addresses all being in column A but different rows, I need to transpose them to be on the same row but different columns. I can do them individually with the paste special transpose function, but doing it over 11,000 times is going to take me forever. There has to be a quicker way to do them all at once. I also have the list in word if that would make a difference.

Thanks

This discussion is locked

All Comments