Consider the example below when filling in empty cells with similar cells (e.g., 'USA') in the Country column.
Perform the following steps:
After performing these steps, the blank cells will be filled with 'USA' for each row as shown below. This feature is can be beneficial when exporting data to another application.
