From the course: Excel: Power Query (Get & Transform) (2020)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Append multiple sheets

Append multiple sheets

From the course: Excel: Power Query (Get & Transform) (2020)

Start my 1-month free trial

Append multiple sheets

“

- [Instructor] You and I have a company where we do maintenance on aquariums. Well, we would like certain information about January through June and we got this workbook that has each month on a separate tab. How do we answer a question like how many freshwater tanks versus saltwater tanks? How many repeat clients do we have? Can we compare residents versus non-resident locations? We need to get 'em all in one place so that we can then do our analysis and it's not going to be so hard. Here's how we do it. I'm going to open a new workbook. And I'm going to close the other one. Maximize. Now, bring this into Power Query data, get data from file, from workbook. Now I'm going to navigate to where that file is saved. Desktop, there it is. Append multiple sheets, double-click. Let's look at April as a preview. Beautiful but we're going to select the folder. That represents the full file and not just a sheet. Transform data…

Contents