Chapter 13
Transforming data with Power Query
Splitting each delimiter to a new row
Appending one worksheet from every workbook in a folder
Appending worksheets from one workbook
Creating a custom data type in Excel
What if there was a tool that let you clean data 20 percent faster on day one? What if that tool accurately remembered all your steps so you could clean the data 99 percent faster on days 2 through 750? That tool has been hiding on the Data tab since Excel 2016.
Power Query is the best feature to arrive in Excel about which most people have never heard. After Excel 2013 was released, the Power Query add-in was released for Excel 2010 and Excel 2013. The add-in was great, but many people in corporate environments ...
Get Microsoft Excel Inside Out (Office 2021 and Microsoft 365) 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.
