I have a block of cells that contain {=SQL.REQUEST($A$5,,,$A$6)}.

Since I don't know how many records will be returned, I have more rows
than I think would ever be returned that contain this array formula
statement.

The rows below the end of the data contain #N/A.

Is there any method to eliminate the #N/A or the formulae in these
cells?

I'd like for the block of data to contract or expand based on the
number of records returned by the SQLREQUEST funtion. Any ideas?

Thanks, Mark