From the course: Excel: Power Query (Get & Transform) (2020)

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Add column by example

Add column by example

From the course: Excel: Power Query (Get & Transform) (2020)

Start my 1-month free trial

Add column by example

“

- [Instructor] Power Query's Column By Example can be really handy, but it is not perfect so we have to watch it. So in this video we are going to play with Add Column By Example to see where it's strong, where it's weak. All right? We've got this dataset with names, we got Mentors, Favorite Colors, Extensions, now let's see what is the deal with Add Column By Example. With our cursor in the dataset. Data, From Table/Range. You know the deal, all right. Here is our data. Going to go to Add Column, Column From Example. Let's first get the first initial, a period, and then the last name all caps. B period ROWE, Enter. Okay? Notice that gray text is guessing, is this what we want? That's not quite it. Let's go down to the next one, A period CHEVALIER, Enter. Let's take a look. Great, everything looks good. So what we'll do since we want to accept this, we hit OK and now we have that new column. I'm going to…

Contents