Now, go to “Data” tab and click “Refresh All”!Īnd that’s it, our data is refreshed, and the new data is loaded: Here’s the additional sales data from 2019:Īll you have to do is to make sure to save the “Sales 2019” file in the same folder as the other files! Now, here’s the really cool thing about Power Query – If you will add a new sales file to the folder, let’s say – “Sales 2019” data, it will automatically be updated in the consolidated file! What happens if we update data in the folder? We can see in the “Source.Name” column the name of the file from which we imported the data!Īnd here we can see the data from all the years □ ![]() Just one more step… Click Close & Load and Select Close & Load, to load the data as an Excel table to your Excel workbook!Īnd now we can our data in the Excel Workbook: Now, we can see a preview of the data from all the Excel files combined: Next, Power Query asks us to show us an example file to understand how to combine the files. Next, we have to click the button circled in red: ![]() Now, we can see in the Power Query editor the Excel files. Click Transform Data (or Edit Data, in previous versions): ![]() Now, we can see the files that we have in the folder. Now, select the folder which contains the Excel files you want to combine and click OK: Then, go to “Data” tab – Get Data – From File – From Folder: We can quickly combine the data from each of these files using Power Query!įirst, let’s open a blank Excel workbook.
0 Comments
Leave a Reply. |