How to pick all the data between two rows

[amsrivastava]

Hi Folks,

I have a data as shown below:

Col A	Col B	Flag
ABC	AS
XCV	S	1
SDF	ASA
23	23
r	4	1

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

[BRRLL99]

this is your expected output ??

XCV	S	1
SDF	ASA
23	23
r	4	1

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

[Qiu]

@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.