# Removing empty and invalid rows

Using the quality bar is a quick way to remove the rows containing invalid or empty records for a given column.

Let's take the example of a dataset containing some customer data. One of the column contains email addresses but some of the entries are either invalid or empty.

![Dataset containing customer information containing invalid or empty entries.](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Resources/images/removing_empty_invalid_1.png)

You are going to use the quality bar to directly delete all the rows containing empty or invalid values for this column

## Procedure

1. Click the black part of the quality bar, under the column header.
2. In the drop-down menu, click Delete the rows with empty cells.

   The empty cells of the column have been deleted and only the invalid values, represented by the red bar, remain.

   ![Invalid values represented.](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Resources/images/removing_empty_invalid_2.png)
3. Click the red part of the quality bar.
4. In the drop-down menu, click Delete the rows with invalid cells.

## Results

Your column is now cleaned of all invalid data or empty cells.

![Valid values represented.](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Resources/images/removing_empty_invalid_3.png)