Keep Table Section Filter

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.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us