13. Transforming Data

Excel 2016 adds amazing tools to Edit, Transform & Load data into Excel. The tools available in the Power Query add-in are now part of Excel 2016, rebranded as the Get & Transform group on the Data tab. This chapter introduces some of the tools available in Power Query as well as traditional tools such as Sort, Filter, Remove Duplicates, and Flash Fill.

Using Power Query

The Power Query add-in was created to make it easier to clean ugly data. Suppose that your IT department provides a data set every day that has a number of problems. Rather than wait for the IT department to rewrite the query, you can use Power Query to memorize the steps needed to clean the data. When the IT department provides a new file, you simply refresh ...

Get Excel 2016 In Depth now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.