Filling empty cells with data from another column

The white part of the quality bar indicates that the column contains empty records.

You will fill the empty cells from the phone number to use, with landline numbers extracted from the phone column.

Procedure

Select the phone number to use column.

You can identify columns containing empty records using the quality bar. The white part of it indicates that the column contains empty records. Data that matches the column type is shown in green, while orange shows invalid data that does not match the column type.
In the functions panel, type Fill empty cells with text and click the result to open the options for the associated function.
Configure the function as follows:
- In the Use with field, select Other column.
- In the Column field, select phone.
Click the Submit button to apply the function.

The empty cells in the phone number to use column are filled with data from the phone column.

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!