Flash Fill automatically fills your data when it senses a pattern. For example, you can use Flash Fill to separate first and last names from a single column, or combine first and last names from two different columns.
Enter the first row yourself, then press CTRL + E to have Excel do the rest.
Saves you having to type out formulae, save time and do this instead!