Excel's Paste Special Function - Change Formulas to Values and Flips Data From Rows to Columns

A few examples of how Paste Special can make copying things easier in Excel.