Select a block of cells based upon a condition

[#1]

I would like to select a data table cell containing a specific string and any populated rows in the same column below the string until I reach an empty cell?  If Value were the text, I'd like to grab the ones below that.  Can't immediately think how to do that.

 to 

 

[#2 · Accepted solution]

Try this

names default to here(1);
dt=current data table();

flag=0;
for each row(
	If(:theColumn == "Value", flag=1,
		:theColumn == "", flag=0
	);
	If(flag==1, dt<<select rows(Row()))
)

[#3]

txnelson

That's brilliant, and really close!  It selects the entire rows but I'd like to constrain it to cells in 

:theColumn

[#4 · Accepted solution]

txnelson

Small tweak got me there.  Thanks.

names default to here(1);
dt = current data table();

flag=0;
for each row(
	If(:theColumn == "Value", flag=1,
		:theColumn == "", flag=0
	);
	If( flag==1, dt << select rows(Row()))
);

dt << Select Columns(:theColumn);