“Get & Transform” in Excel: A Powerful Tool for Importing and Manipulating Data
The “Get & Transform” tool in Excel 2016 for Windows is a real game-changer. It enables data imports from a wide variety of systems and software – Access, ERP solutions, accounting software – and moves it into a worksheet that transforms the original information into a new format of choice, which Excel remembers for next time. Even better, it’s all done with a point-and-click wizard-like interface. Practical applications for Get & Transform will be covered in this session: as an alternative to VLOOKUP list comparisons, an automated way to flatten and format data, a method for un-pivoting summarized data, an easy solution for merging several CSV export files into one, and more. Learn to move past copy/paste and time-consuming manual data manipulation with this powerful tool.