From the course: Excel: Managing and Analyzing Data

Unlock this course with a free trial

Join today to access over 24,400 courses taught by industry experts.

Import and combine data sets in Power Query

Import and combine data sets in Power Query - Microsoft Excel Tutorial

From the course: Excel: Managing and Analyzing Data

Start my 1-month free trial Buy for my team

Import and combine data sets in Power Query

“

- [Instructor] I'm about to show you something that I go into at a deeper level in my Power Query course on the library. So please check that out, if you haven't. What we're going to do now is talk about sweeping data together in one place. Several times in the course, I mentioned the importance of keeping your data in one place are as few places as possible or to make sense. That's great if you are starting your own workbook from scratch and have the foresight. But sometimes, we receive a workbook like this one, and here, we have three different tabs: The Fizz Group, Minotaur group, and the Starlight Group, and all of this data. Now let's look at the other sheets, right? Same format, and same format with the name, start date, airport, et cetera, whether we have an address on file or not. And this is fine if you just want to look at the Starlight Group on its own, or Fizz, et cetera. But what if we want a count of everybody, regardless of the list? What if we want to find out how many…

Contents