# Remove Data Row/Column

> The example below explains how to remove rows and columns from a DataTable by using the [Remove Data Column](https://docs.uipath.com/activities/other/latest/workflow/remove-data-column), [Remove Data Row](https://docs.uipath.com/activities/other/latest/workflow/remove-data-row), [For Each Row in Data Table](https://docs.uipath.com/activities/other/latest/workflow/for-each-row), and [Get Row Item](https://docs.uipath.com/activities/other/latest/workflow/get-row-item) activities. You can find these activities in the package.

The example below explains how to remove rows and columns from a DataTable by using the [Remove Data Column](https://docs.uipath.com/activities/other/latest/workflow/remove-data-column), [Remove Data Row](https://docs.uipath.com/activities/other/latest/workflow/remove-data-row), [For Each Row in Data Table](https://docs.uipath.com/activities/other/latest/workflow/for-each-row), and [Get Row Item](https://docs.uipath.com/activities/other/latest/workflow/get-row-item) activities. You can find these activities in the package.

This is how the automation process can be built:

1. Open Studio and create a new **Process**.
2. Drag a **Sequence** container in the **Workflow Designer**.
   * Create the following variables:

     | Variable Name | Variable Type | Default Value |
     | --- | --- | --- |
     | `DT1` | **DataTable** |  |
     | `RemovedRows` | **List<DataRow>** | **new List(of DataRow)** |
     | `StringDT` | **String** |  |
     :::note
     Add your `.xlsx` files to the project directory in order to be able to run the entire process from the same place.
     :::
3. Drag a **Read CSV** activity inside the **Sequence** container.
   * In the **Properties** panel, add the expression `"challenge.csv"` in the **FilePath** field.
   * Select the **Comma** option from the **Delimiter** drop-down list.
   * Select the check box for the **IncludeColumnNames** option.
   * Add the variable `DT1` in the **DataTable** field.
4. Place a **Remove Data Column** activity below the **Read CSV** activity.
   * In the **Properties** panel, add the expression `"Phone Number"` in the **ColumnName** field.
   * Add the variable `DT1` in the **DataTable** field.
5. Drag a **For Each Row** activity below the **Remove Data Column** activity.
   * Add the variable `DT1` in the **DataTable** field.
6. Select the **Body** container of the **For Each Row** activity and create the following variables:

   | Variable Name | Variable Type | Default Value |
   | --- | --- | --- |
   | `Address` | **GenericValue** |  |
   | `AddressNumber` | **Int32** |  |
7. Place a **Get Row Item** activity inside the **Body** container.
   * In the **Properties** panel, add the expression `"Address"` in the **ColumnName** field.
   * Add the value `row` in the **Row** field.
   * Add the variable `Address` in the **Value** field.
8. Drag an **Assign** activity underneath the **Get Row Item** activity.
   * Add the variable `AddressNumber` in the **To** field.
   * Add the expression `CInt(Address.Split(" "c)(0))` in the **Value** field.
9. Add an **If** activity below the **Assign** activity.
   * Add the expression `AddressNumber >= 10 And AddressNumber <= 50` in the **Condition** field.
10. Drag an **Add to Collection** activity in the **Then** field.
    * In the **Properties** panel, add the variable `RemovedRows` in the **Collection** field.
    * Add the value `row` in the **Item** field.
    * Select the **System.Data.DataRow** option from the **TypeArgument** drop-down list.
11. Drag a **For Each** activity below the **For Each Row** activity.
    * In the **Properties** panel, select the **System.Data.DataRow** option from the **TypeArgument** drop-down list.
    * Add the variable `RemovedRows` in the **Values** field.
12. Place a **Remove Data Row** activity inside the **Body** of the **For Each** activity.
    * In the **Properties** panel, add the variable `DT1` in the **DataTable** field.
    * Add the value `row` in the **Row** field.
13. Drag an **Output Data Table** activity below the **For Each** activity.
    * In the **Properties** panel, add the variable `DT1` in the **DataTable** field.
    * Add the variable `StringDT` in the **Text** field.
14. Add a **Write Line** activity under the **Output Data Table** activity.
    * Add the variable `StringDT` in the **Text** field.
15. Run the process. The robot removes the specified fields from the provided table and prints the new DataTable in the Output panel.
* This is how your workflow should look:

  ![docs image](https://dev-assets.cms.uipath.com/assets/images/activities/activities-docs-image-185346-528bbc26.webp)

[Here](https://docexamples.uipath.com/examples/Activities/Remove%20Data%20RowColumn%20-%20Example.zip) you can download an example.