Paste Special Macro

Hello –
I need to do a bunch of Paste Specials with the option to transpose data. Under customize I know you can choose Paste Special, but then you still have to select transpose each time. Anybody know of a macro for Paste Special Transpose? OR an easy way to move data from rows to columns. For example:

ABC Company
1234 Main Street
Anytown, USA 02021
(the data is in rows)

needs to be

ABC Company 1234 Main Street Anytwown, USA 02021

(data needs to be in columns)

Unless, you can mail merge from rows instead of columns. HELP!

Thanks!