Excel’s Flash Fill vs Power Query’s Column by Example

/in /by

This video shows 2 examples of messy data and how they’re handled by Excel’s Flash Fill and Power Query’s Column by Example.

We have to merge first names and last names but also, deal with all caps, lower case, and get the names into proper case, but also there are prefixes like ‘Rev’ that we don’t want.

Flash Fill proves to be more robust–able to handle more complex situations, but the results are static. Column by Example, however, can be automated and that’s it’s most glorious aspect.

Watch the video and see how they compare.

#FlashFill #PowerQuery #ColumnByExample

For an intro to Get & Transform (Power Query) try my Lynda/LinkedIn course:
https://www.linkedin.com/learning/instructors/oz-du-soleil?trk=insiders_28299411_learning
Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

My old blog: http://datascopic.net/blog-2-2