Video: Flash Fill
Use Flash Fill, new in Excel 2013, to fill out data based on an example. Flash Fill typically starts working when it recognizes a pattern in your data, and works best when your data has some consistency.
Other videos in this course
This video is part of a training course called Use AutoFill and Flash Fill.