Excel Power Trick – How to Combine a Folder of CSV Files

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…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads