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. Let's say column A contains first names, column B has last names, and you want to fill column C with first and last names combined. More @Wikipedia
Hover over any link to get a description of the article. Please note that search keywords are sometimes hidden within the full article and don't appear in the description or title.