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 ...