Paste special and transpose in Excel

There are a few ways to do this, but if you're looking for a non-macro shortcut, try this:

Select the cells you want to copy. Ctrl-C to copy. Select the cells where you want to paste. Holding down Alt, type E S E. Choose the options you want in the paste special box (i.e. check values, transpose). Click OK.

Many thanks to MrExcel.com (John) for this tip! He also spells out the macros if you want to go that route here.