How it works
This function allows users to delete specific rows from a dataset based on a value in a single column.
How to use it:
Step 1
In the ‘More’ drop down of the Cleaning and Structuring Workflow group, click on ‘Delete Rows Per Value’.
A new pop-up window will appear.
Step 2
Select the Column header within which the value will be found.
Step 3
Populate the value to be used to identify which rows to remove.
Note: This is not Case-Sensitive.
Step 4
Click OK to execute the function.
On completion, a new Sheet excluding the rows will be populated.
