Do you ever get a spreadsheet with the data not quite the way you need it? Maybe you have a first name and last name in separate cells but you need the Full name. What about the opposite problem of a full name cell that you want to separate into first and last name cells?
This 3 1/2 minute video will explain how to use Flash Fill to get your data the way you need it.
![Aiko Excel Technotherapy](https://aikotekusa.com/wp-content/uploads/2021/06/Excel-Flash-Fill.png)