Note: Because this is an ongoing series, viewers will not receive a certificate of completion.
Skill Level Advanced
- [Narrator] It was a cold, cold Thursday night, when an email arrived that I'd been waiting for. I had asked my assistant please, match these units and residents with their email addresses. The email addresses are over here. And notice, we have 27 email addresses, we have 18 people and look at the result. 26 that is wrong. Moreover, look at Mike Jones and Mike Sanford. Two different people, two different units, one email address, no, no, no, no, no, no, no. And then, in the data tab, I'm going to go to queries and connections, there are three query. So this was a Power Query solution. Let's go back to the main page, please troubleshoot and correct whatever has gone wrong in this workbook. Pause the video now. Work it out, come back, and we'll go through it together. Okay, you're back. Now the first thing that I notice with this data, we've got Bessie Alvarado, Mira Alvarado. Then we have Nathan Finch and Nathan Moel. That is telling me we have to do a join with two criteria. Let's see if my assistant did that. Go to merge, double click it. Let's go to source, I'm going to click this gear. No, my assistant did not do the two columns. Lets do that right now. Last name, matches with last name. And then hold down the Cotrol key. F name, first Name. Look at the bottom, the selection matches 18 of 18. That is what we wanted. Click Okay. Slide down here. Close and Load. And here is the joyful ending to end the nightmare that started that cold, cold Thursday night.