Learn how to combine data from multiple workbooks into one master worksheet using Excel Power Query. We'll go over a quick and easy way to get this done when you have your setup done correctly and we'll make sure that it automatically updates with changes in source files. More advanced techniques will be covered in a separate video. Compatibility: Windows Only, Excel versions 2010 or above. Versions 2010 & 2013 must install add-on Power Query ( ). Versions 2016 or above don't need to install anything, it's included in your version.
#excel #combine
0 Comments