You can take the data from any column, and use it to consolidate
another.
Now that only the mobile phone numbers are selected, you will use these values to replace
the wrong numbers in the Phone number to use column.
Procedure
-
Select a column in which you want to replace values, Phone number to
use in this example.
-
In the Functions panel, type Fill cells with
value and click the result to open the options for the associated
function.
-
Configure the function as follows.
Make sure the Filtered rows option is selected in
order to only apply the function on the filtered lines.
-
Click the Submit button to apply the function.
The filtered content of the selected column, Phone number to
use in this example, is replaced with the data from the
Phone column.
-
In the filter bar, click the garbage bin icon to clear the filter and display
the whole dataset again.
Results
You have used the filtered data to update the information of the consolidated
column.