I have about 50K entries in one row that need to go from vertical to
horizontal. Each is a name, address, etc., so when I get done it should be
about 10K entries. Right now it looks like this:

Name
Address
City, ST Zip
Phone

And what I'm wanting is Name | Address | City | ST | Zip | Phone

I know I can do each row separately (copy / paste special / transpose), is
there a faster way to execute it in bulk? Thx!