Jan 10 2017
- last edited on
Jul 12 2019
Get & Transform (Power Query) is amazing at connecting to and transforming data.
You just build the connections, do the transformations once, and then simply refresh anytime you want to update the data.
Power Query is built into Excel 2016 and is a free download for Excel 2010 and 2013
Check out this 4-minute video which steps through the process of combining the data from every CSV file in a folder into one table, then impress your colleagues as you replicate this demo for them!