Sometimes you need to enter a lot of repetitive information in Excel, such as dates, and it can be really tedious. But the AutoFill feature can help. Or say you have information in Excel that isn’t formatted the way you need it to be and going through the entire list manually to correct it is daunting. In this case, Flash Fill (a new feature in Excel 2013) can do the work for you. Flash Fill is on by default and automatically fills your data when it senses a pattern.
Excel – Flash Fill YouTube Video
Here is the Microsoft support article for flash fill.