From the course: Excel: Managing and Analyzing Data

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

Using the Power Query joins feature

Using the Power Query joins feature - Microsoft Excel Tutorial

From the course: Excel: Managing and Analyzing Data

Start my 1-month free trial Buy for my team

Using the Power Query joins feature

“

- [Instructor] Here, I'm going to show you two of Power Query's six joins, or sometimes they're called merges. On the library, I do have a full course where I go really deep on the joins because they are so valuable. So I encourage you to check out that course. Meanwhile, for this course, I'm going to introduce you to the joins. Now, here are owners and residents. On the owner's side, there's Andy who owns unit G, and on the residence side, Andy lives in unit G. You can see Cassius owns unit A, but on the resident side, Leah is the one who lives in unit A. And notice also, what's important is this other data that we have. We've got units, phone numbers, the number of bedrooms in each unit, and the car park assigned to each resident, if they have one. See, Hannah doesn't have one. So that's where we are looking at the matches or joins or merges. So let's get into it. First of all, with Power Query, we need to…

Contents