32 - Add Column from Examples in Power Query in Excel

In this video, I will show you how to add a column from example in your data in Power Query editor. In this, you can create a column and enter some text and power query uses that to decipher what you want in the column.

This is similar to the flash fill option we have in Excel that tries to understand the pattern and use it to fill the column

#Excel #PowerQuery #ExcelTips

[DushiTeraPaSalsa]

How great this option is, so simple and very very under rated. If there were two likes i would shared it. Thanks :)

[HARSHITAPUNEET-dj]

This function is not there in my excel

[smartzthiha]

Thanks. This is the part I like most in Power Query

[surajkapure]

how do I insert manual data entry column in query and it should not go away when I refresh the data set. ? I mean data with respect to the row should present there after refreshing it... Also thanks for this learnings, it really helping me alot

[vasimuddinsheikh]

Sir plz change the name Laura with something else... Some time it make us feel like

[required.]

How can power query be so powerful ?? without AI ? can anyone tell about its code ?

[surajbhardwaj]

Column from example option is great, here i can check the function also simultaneously.

[carsonblocker]

Dear TrumpExcel: Thanks for putting out these helpful videos. You make the world a little bit smarter with each one.
I am trying to figure out how to import data from a CSV file, but only some of the headers (columns) based on that the header name is (row 1 is the headers). Also, the header order may change in the sourse.csv file 9out of my control). I've been working my way through the playlist to see if there's an answer here.

[lakshmikanthd]

Add column from example option is not showing in my 2016
What can I do

[naveenmedishetty]

Thank you so much. Your videos as good as donald trump decision