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
Get more details and information HERE.