Fill missing values

Fill missing values

    1. Click on the Data menu.

    2. Navigate to the Data Cleaning tool, and from the drop down choose Fill Missing Values

    3. In the data cleaning tab, choose a column for the tool to pick up the empty cells from.

    4. Once the tool is done picking up empty cells, please select one of the three options provided to fill the cells with a value that you want.

    5. You can either choose to fill all the missing values with a specific value, or fill it with the content in the previous cell or you can choose to fill the cells with the most occurred value in the column.

    • Related Articles

    • Apply a solid color, gradient, picture and pattern fill

      Fill the empty spaces inside your shapes to make them stand out on the presentation screen. Adding fills such as blended-color gradients, two-color patterns, or pictures to your slide objects not only helps your audience easily capture the ...

    • Add a Solid Color, Gradient, Picture and Pattern Fill to Objects

      You can change the look of a shape, table, chart, or text box by applying a fill color, pattern, texture, picture, or gradient to the interior of a chosen object in Zoho Show. Solid fill applies a single color uniformly within the whole of an ...

    • Missing Overlay Icons in Desktop Sync

      In Desktop Sync, the following overlay icons will appear on individual files and folders indicating their sync status:    The file/folder has been fully synced.    The file/folder is being synced.    The file/folder could not be synced.   General ...

    • Need to share the Document with Read-Fill Permission

      We are working on making the documents fillable; but, not editable while sharing them in read-fill mode. It will be made available very soon. Timeline : Roadmap

    • Custom Function: Computing_Field_Values

      This custom function can be used to add two values and save the return value in a custom field.  The sum will be dynamically updated in the custom field after this function is executed.  Business Scenario Helen is the head of Procurement ...