 We've done five now. Or is it six? I think we've done six. So number seven, also number seven, create columns from example, Flash Fill. Interesting. Let's show you how it's done in Excel. Let me open something in Excel so you understand what Flash Fill does in Excel. It's such an excellent tool in Excel. Many people don't even have forgotten about it or don't even know about Flash Fill. So look at these names, right? These common names we have. Let's assume I just want the surname and then I want the first name. So I want the surname and first name. Now, if you're very good in Excel, right, you would do some really fancy formulas. Now, let me just, should I show off my Excel skills? No, I'm not. Okay, well, what is the delimiter? There are two delimiters here. What is stopping? How do you know the surname or how do you know the first name? Well, the surname has a comma after it and then has a space. So what you could do, you could search for, let's say you could search for comma within this guy, right? So when you search for it, it says a seven. So if it's seven, that means you have six characters for the surname, right? So if I drag this down a little bit, you see that this is seven, seven, nine, nine, nine. Oh, that's strange, all nine. Okay, and then this is seven, right? Now you have seven and nine. What kind of names do we have here? Okay, 11 and five, better. So seven. So what we now need to do is come in here and then say, you know what, I want you to extract from the left, not to extract from the left, extract names from the left. And how many characters are extracting? This is seven, remember, minus one. I close our bracket and then you get his name. Right. But this is too much stress. And so what Excel did, which is so cool, you should just type, just type Cabral. So I'm just going to type Cabral. Then I type a second one and that would be like an example. I type Fallon. And guess what? Excel has an idea, says, hey, I know what this guy's doing. And let me give him an example. Okay, I will show him, if he's happy with what he wants, then he should just type enter. So I just type enter, guess what? It just came out. Perfect. So first name, same thing, same trick, Michael, or Michael, sorry, Michael, I'll spell it the other way. Now, another trick, a shortcut for Flashfill is actually Ctrl E. So I don't need to give it another example like a sales teller, look, do you know what, use this guy and just fill it, Ctrl E. So it did Ctrl E and it filled out. So this is Excel. It's quite impressive in Excel, yes? But let's do all these tricks. Let's do the same trick in Power Query. You don't want to do in Excel because Excel means you need to do this every month. In Power Query, it is automated. So just know that Excel is good, or Power Query is better for some things. So I'm going to close this, don't save, minimize, and let's do this creating columns from example Flashfill inside Power Query. So I go to Edit and Edit Queries. And then now I need to go and look for what file should we use? Let's see. See this? Yeah, we could use this guy, right? Yeah, so let's use this. I'm boring from this. I don't know who used this. Can you remember? Well, there's a trick that would tell you, okay, who is using what? So we don't mess things up. I'll show you that trick later. But I'm going to duplicate this just in case. Duplicate, right? And then I'm going to rename this guy. Let me call him Flashfill. I can't spell Flashfill. Okay, so Flashfill. I need to fill this just like I did in Excel. So how do I do that? Well, there's a wonderful new tool. They added, I can't remember when this was added, but columns from example, column from example. Column from example is a new tool. So I click on the drop down and I say from all columns or from selection. Well, I've already selected this. This is the example I want to use. So I say from selection. So what it does is just gives me this box here. And inside this box, all I need to do is type. So I just start typing, just like Flashfill. Right. And then I enter. When I enter just like Flashfill, if you remember how we did it in Excel, all I need to do is now say, okay, once I say, okay, see it's filled it out, I can call this the surname. Right. Then I can still go back and select the same column like this. And then say I need another example from selection. And then this time around, obviously I'm doing the surname, right? Or the first name. So it's my, my call. And enter. And you can see it's already filled it out. You just needed one example and just say, okay. And then this is the first name. Now remember this is power. I don't really like space. So this is power query. So when your data grows, you never ever need to do this again. It's just automated. That's why this is more superior than your Excel. So if I drag this to the left, let's just put the names close to the surnames, everything is recorded. And if you look to the right, you see that this is being recorded. And in fact, let's even look at the formula, the M code, you know, power queries language is M. So let's have a look at the M code it used to do this automatically. If I click on this, this is the M code up here or not, not the M code. Let's click on, where is that? Insert text delimiter. So look at the M code it used. Now if I put on the magnifier, let's just see if you can see that. Let me get my magnifying glass up. So this is the M code. Looks ugly. Table.add column, rename columns with the hash, then text after delimiter, each text dot after delimiter name, comma space. So all that story just see the space, just that space. Now similar to how we did it in Excel. But that's power query. Then you can actually use this to learn how to write M code. Okay. So that is how we do it.