From the course: Data Wrangling in Excel with Power Query
Unlock the full course today
Join today to access over 24,100 courses taught by industry experts.
Using the Column from Example feature - Microsoft Excel Tutorial
From the course: Data Wrangling in Excel with Power Query
Using the Column from Example feature
So the last activity I want to show you is called column from example. And what I'm going to do here is I'm going to hold shift. I'm going to click all the way through job category. I'm going to right click and hit remove columns because I just want to remove those columns for this step. Okay. So and then we have the last name right here. I'm going to move that back and that's fine. So what I want to show you here with column by example is that there is kind of a macro recorder in power query, but it's not necessarily this. So let's say there is something you wanted to do, but you didn't know how to do it right. You're like, I need to figure out how to, in the barest, easiest example, right, would be how to pull the domain out of this email. So I'm going to click on email because that's the column I'm interested in and I'm going to the add column tab and I'm going to click column from examples and I'm going to click from selection and not all columns. So we're going to insert that…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
(Locked)
Wrangling dirty data in Excel with Power Query3m 43s
-
Data wrangling steps12m 7s
-
(Locked)
Using the Power Query Applied Steps to track actions8m 5s
-
(Locked)
What M code is and where to find it3m 52s
-
(Locked)
Tour of Power Query features13m 6s
-
(Locked)
Using the Column from Example feature4m 48s
-
(Locked)
Sending feedback to Microsoft2m 38s
-
(Locked)
-
-