How to Remove all Rows after a Specific Row

[Junnel_8533]

Hello! Would just like to ask if there is a way remove all the rows after the row that has a subtotal. Kindly see screenshot. On this example I want to remove all rows after 492 (Row 493 and all succeeding rows after). I want to know if there is a dynamic solution as the row number with subtotal might change (e.g. subtotal might be on Row 392 when I next run the workflow, hence, I need to remove all rows from 393 and after). Thank-you very much!

[ShankerV]

Hi @Junnel_8533 

One way of doing this.

Output:

Input was

Hope this helps!!!!

Many thanks

Shanker V