![]() What we need to do is replace the second line (Source = “”) with the following two lines of code:įullFilePath = "D:\Temp\Combine Worksheets.xlsx", You’ll now see the following blank query: Go to Power Query –> From Other Sources –> Blank Query. ![]() How do we get at the worksheets?īasically, we’re going to start with two lines of code: Naturally we’re going to reach to Power Query to do this, but how do we get started? We could just go and format the data on each worksheet as a table, but what if there were hundreds? That would take way too much work!īut so far we’ve only seen how to pull Tables, Named Ranges or files into Power Query. Now the file lands in our hands (you can download a copy here if you’d like to follow along,) and we’d like to turn this into one consolidated table so that we can do some analysis on it. But unfortunately, they haven’t formatted any of the data using Excel tables. It is all structured as per the image below, but resides across multiple worksheets one for each month:Īs you can see, they’ve carefully named each sheet with the month and year. Let’s consider a case where the user has been creating a transactional history in an Excel file. This week we’re going to stay within the same workbook, and combine multiple worksheets using Power Query. ![]() In last week’s post we looked at how to combine multiple files together using Power Query. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |