What's So Special About 'Paste Special' In Excel?

The tool "Paste Special" in Excel can do so much more than just pasting values or formats. Here's how you can use it to transform your data in a variety of different ways.