With the Coalesce columns function, you can easily retrieve the first non null value across different columns to consolidate their data into a new column.
In this example, you are working on a dataset that contains information about your customers, including the different phone numbers at which you can reach them: office, mobile or home number. You can notice that some values are empty. Because you do not necessarily need to have 3 columns with similar information in your dataset, you can choose to create a new one containing only one phone number for each row, and make sure that the empty values are replaced with usable information at the same time. Here, you want to prioritize the mobile phone numbers, and retrieve the office or home number as backup.
Procedure
-
To prioritize the mobile phone number over the other numbers,
drag the phone_mobile column header and
drop it left of the phone_office
column.
The columns are now ordered as following:
Results
