What is it?
The Keep Table Section filter is used for defining the beginning and end of a table you need to capture based on keywords or data types occurring within a specific column.
How is it used?
Add Table Filter Remove & Merge Rows Keep Table Section
The Keep Table Section has four primary modes:
- The first, Section Starts & Ends When for defining the beginning and end of a table based on specific keywords or data types occurring in a specified column.
- The second option is to use a fixed rows range where you can define a beginning and end row.
- The third option “Crop Rows from Beginning & End” for trimming a table and the final option for retaining rows only from the beginning or end of a section.
- A Keep Table Filter can be applied as many times as needed and combined with other table filters to help locate and return the correct information.
How to Use the Keep Table Section Filter