How to convert columns to rows, or rows to columns in MS-Excel

Have you ever had a list or data set in Excel that was in columns and but you really wanted to see it listed in rows? I usually run into this once every 3-5 years. Thankfully Google is now here to save the day when you can't remember how you did it last time. If you have MS-Office 2003 or newer you can copy your set of data (in rows or columns), move to a blank cell and click paste->special and select the transpose button and you're done. How did we ever get things done before Google?