How to pick all the data between two rows

Question

Hi Folks,

I have a data as shown below:

Col ACol BFlagABCAS XCVS1SDFASA 2323 r41

Note :

1. Here number of columns can be any, i,e. Col A, Col B , Col C etc.; number of columns are dynamic.

2. Flag column is fixed.

3. Flag will have value as 1 in any 2 rows always.

I need to pick all the rows where FLAG=1 , i.e in above e.g. all the rows where text highlighted as RED.

So, basically, wherever there are two occurrences of Flag=1 in the data, I need to pick all the rows between those rows.

Thanks

Amit

Qiu · Answer

@amsrivastava 
I was trying the multi-row formula but it did not work for me. 
So I assign the record ID to each row then find the Row numbers for the flag rows.
Then filter out the rows in between.

0527-amsrivastava.yxmd

BRRLL99 · Answer

this is your expected output ??

XCVS1SDFASA 2323 r41

you need to Fill down the flag column

use multi row formula and then add filter = 1

IF IsNull([flag]) or ISEMPTY[[flag])
THEN [Row-1:flag]
ELSE [flag]
ENDIF