Remove blank rows action in Apple Numbers package

The Remove blank rows action of the Apple Numbers package enables you to remove the blank rows from the active or specified table. This helps keep your data clean and ensures your automation runs efficiently without processing unnecessary rows.

Settings

  • Use one of the following options to provide session name:
    • Session name: Enter the name of the session used to open the spreadsheet with the Open action.
    • Variable: Enter the session variable that you added in the Open action.
  • In the Select table field, choose from the following options to remove the blank rows from the specified table:
    • Active: Removes blank rows from the table currently in focus.
    • Specific: Enter the table name where blank rows should be removed. Example: Table 1.
  • To remove blank rows from the specified table, indicate the range selection in the Start from and End at fields:
    • Start from: Choose one of the following options to set the starting point for removing blank rows:
      • Beginning of the table: Starts at the first row of the table.
      • Specific row
        • Row number: Specify the row number as the starting point. For example, 8.
        • Cell address: Specify the starting cell address. For example, A5.
    • End at: Choose one of the following options to indicate the endpoint for removing blank rows:
      • End of the table: Continues to the last row.
      • Specific row
        • Row number: Specify the row number as the endpoint. For example, 10.
        • Cell address: Specify the ending cell address. For example, A10.
When you specify the attributes mentioned above, any blank rows between, and including, the Start from and End at locations will be removed from the specified table during the action's execution.
Note: You cannot delete all rows or all columns in the table using this action.
Important: The following behaviors apply to the Remove blank row action:
  • Preservation of table header and footer: The header and footer rows of the table will never be deleted, even if they are blank. These rows are considered part of the table structure and are excluded from the removal of blank rows.
  • Single row table: If the table contains only one row of data, that row will not be removed, even if it is blank. This ensures that the table always retains at least one editable data row.
  • Headers and footers are not counted as data rows: Header and footer rows are not counted as part of the table’s data rows. Therefore, a table that includes a header, a footer, and one blank data row will retain the header, footer, and the single blank data row (the blank data row is not removed).