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.