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.
This story originally appeared on Business Insider