Need to add 'Other' In Blank or empty Column

Hi team, Please refer example sheet below. I need to add 'Others' in blank rows for all the three columns. Please help, We have three columns by the name of Train, Car and Bike. Train columns has all "Text fields" with some empty row Car column has numeric and text fields both with some empty row Bike column has all numeric fields with some blank row. Please add "Others" in empty rows Train Car Bike tar sa 98 pra 12 kar bt 12 phu rt 39 23 cn 9 33 dt 8 pt 33 cat ar 67 ar for, 12 89 tt tt- 44 tt Thanks Mohammad Mustkeem

Datasets

Accepted answers

danilang

Hi @mmustkee

You can use a Multi-field Formula like this

The Multi-field formula tool is the only tool that can act on the values in a column and change the column type as well. This will be useful here since you need to change the column type of the Bike field from numeric to string since your adding the "Other" string to a column that contains only numbers

The ToString() function around the current field value is required since you have to convert the numeric Bike values into strings to insert them into the Bike column which has been converted to a string