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