Using Flash Fill

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. Click this link for Microsoft's support article on using Flash Fill:  Using Flash Fill in Excel - Microsoft Support.