EXCEL Remove blank rows function

This article describes the RPA Excel functionality to remove blank rows.

For a full list of available functions, please read EXCEL functions.

Description

The EXCEL Remove blank rows function allows you to remove blank rows.

Setting it up

To use the EXCEL Remove blank rows function, follow these instructions:

{{popups:rpas/add:action=excel-remove-blanks}}

Once on a process map:

1. Navigate to the process where you would like to add the EXCEL Remove blank rows function
2. Click on the green button’s drop-down (right side of the green button labelled “Process”)
3. On the menu that appears, click on the “+ Activity” item
4. From here you can select the EXCEL Remove blank rows option
5. Click "Add" once you are done

Input parameters

Output variables

This action does not produce output variables.

Errors

Tips

• Removes rows where the specified columns are empty

Related functions

• excel-remove-rows
• excel-duplicates