This Simple Excel Tool Can Transform Your Data In So Many Ways

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.

Produced by Sara Silverstein.

Watch more Business Insider videos here.

More from Business Insider