About this tutorial:
Video duration: 00:07:12
Download the data set here
Excels Power Query ( or Get and Transform Data in Excel 2016) will allow you get data from almost any source and then transform that data into a usable format
One of the features available is Combine Binary’s. This will allow you combine data contained within a folder.
In this video you will learn how to use Combine binary’s in Excel Power Query (get and transform data) to connect to a folder of CSV files and then transform the data to a usable format.
Once you save your workbook and…