Chapter 13Transforming Data
Appending Worksheets from One Workbook
Splitting Each Delimiter to a New Row
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 two through two hundred? 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 2019 Inside Out 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.
