Flash fill in excel
What is Flash fill in excel?
Flash Fill is a data tool in Microsoft Excel that allows us to combine, extract or transform data based on a few examples. We only need to provide a couple of examples of the results we want, excel will guess the pattern and fill in the rest of the data for us.
In the above gif file, we can see that we only provided one row of input, and after using Flash fill it automatically separates values.
How to Enable Flash Fill in Excel?
To enable flash fill in excel go to File then Options. After that select Advanced and … Continue Reading