Excel University Blog

Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.

FlashFill

Flash Fill Times

By Jeff Lenning | November 26, 2019 |

Flash Fill is a marvelous feature that is designed to fill values down based on an example in an adjacent column. That is, you have a column of values and then you enter an example of a derived value in an adjacent column. Flash Fill attempts to recognize the pattern from your example and then…

Read More
FlashFill Meets GNT by Jeff Lenning

FlashFill Meets Get & Transform

By Jeff Lenning | June 20, 2017 |

Do you love FlashFill? Do you love Get & Transform queries? If so, you’ll love the most recent Excel update pushed out by Microsoft: New Column by Example. It is essentially FlashFill inside PowerQuery. It is way cool. Check it out. Objective Let’s say we have some data. It doesn’t matter where it is, it…

Read More

FlashFill is an Alternative to CONCATENATE and Text-to-Columns

By Jeff Lenning | August 15, 2013 |

Have you ever split one column in to many columns, or vice versa, combined many columns into a single column?  If so, you have likely relied on the text-to-columns feature to split a single column into many and the CONCATENATE function to join many columns into a single column.  Beginning with Excel 2013, Microsoft provides…

Read More