Flash-Fill

You can use Flash Fill or Auto Fill command in Excel. It allows you to automatically fill matched data when it senses a pattern in cell.