Excel Flash Fill is a Programming by Example (PBE) data manipulation tool that is applying machine learning to binary decision diagrams.
It is a Data Tool in Microsoft Excel that will allow to
Analyzes the information entered and automatically fills data when it identifies a pattern.
Flash fill automates repetitive string transformations using examples.
It’s very easy to use and can finish the tasks quickly and Flash Fill will save time in working on complex formulas or writing VBA Macros to the same work.
The Flash Fill feature was introduced in Excel 2013 and is available in all later versions of Excel 2016, Excel 2019, and Excel for Office 365.