Flash Fill
Hello Everyone! In this blog, We will be learning about Flash Fill. What is Flash Fill and What are the benefits of using Flash Fill?
You will be clear after reading this article
Let’s begin.
Flash Fill is a feature in Microsoft Excel that helps you format and clean up data quickly by recognizing patterns in your data and automatically filling in values. It is useful for tasks like separating or combining data, formatting dates, and more.
In this table, we have a Full name column that contains multiple values. We need to Extract numerical value into the Extract Number Column.
First, insert the numeric value of the first row and then Press Ctrl + E. And you will see the magic. Rest values will automatically get filled.
You can also get value by double-clicking the bottom right corner of the cell.
If you are getting the duplicated values. Then Click on the Flash Fill option in the dropdown.
Next, I want to create an email ID from my first name and last name. We just have to manually enter the email ID for the first row, rest gets automatically filled by using flash fill.
Here are the results.
Now, In this table, we need to extract the product number. For that, we can again use the Flash fill feature.
First Enter the number manually and then press Ctrl + E for flash fill. But there is a problem you can not see the leading zeros in the number they are missing as we know product no is in number format and we can not add leading zeros to any number in Excel.
Get Simrangodsey’s stories in your inbox
Join Medium for free to get updates from this writer.
So what is the solution?
The solution is you just have to add a single quotation mark ‘ before the number and press Enter and Ctrl + E.
After adding a single quotation mark. We get the below result.
Thank you for reading. Feel free to share your thoughts, ask questions, and let’s continue this journey together.
If you appreciate my content, consider following my Medium page. I will be regularly posting content related to Data Analytics here.
Additionally, if you’d like to connect with me, you can find my LinkedIn ID and GitHub profile below.
Happy learning!
