Excel Flash Fill on names

I’m sitting in a training session today, and I saw the trainer do something in Excel that I didn’t know was possible… Flash Fill can complete columns of names based on other columns. Here’s how…