FLASHFILL

Flash Fill is a feature in Microsoft Excel that allows you to automatically fill in a column or row with data based on a pattern or example you provide. It works by analyzing the data you've entered in one cell and then using that information to automatically fill in the rest of the column or row. Flash Fill can be a useful tool for quickly and easily cleaning and formatting data in a spreadsheet. To use Flash Fill, simply enter the data you want to use as the pattern or example in the first cell, and then press the Ctrl + E key combination. Excel will automatically fill in the rest of the column or row with the appropriate data.