Consolidating workbooks in excel 2016 policy for updating erp files
I’m just demoing that it isn’t necessary.) The end goal we’re after is fairly common.We basically want to grab the data from each file, strip out the first 4 rows, and append the tables together (without repeating header info.) This will essentially create a nice data source that we can use in Pivot Tables, charts and other tools.By the time we’re done, you’ll see how similar it is to working with non-Excel files.For our example we’re going to assume that we have four (or more) Excel files which you can download here.
It is compatible with Microsoft Excel 2007, Excel 2010, Excel 2013, Excel 2016, and Office 365.
Now think if you open the file one by one and manually combine excel files, how long time will it take?
At the same time, a small piece of macro code will do the trick to merge excel files for you even though you are not a programmer.
So let’s look at how to combine multiple workbooks together in Power Query, providing they have the same format.
Yes, it’s been covered before, (even linked to in the comments of the previous posts,) but I’m going to put my own flavour on it.