There is, but it might be a resource intense formula...
Try:
=IF(ROWS($A$1:$A1)>COUNTIF('IMOS-RE'!$Q$2:Q$1000,"Spanish Eld"),"",INDEX('IMOS-RE'!$L$2:$L$1000,SMALL(IF('IMOS-RE'!$Q$2:Q$1000="Spanish Eld",ROW('IMOS-RE'!$Q$2:Q$1000)-ROW('IMOS-RE'!$Q$2)+1),ROWS($A$1:$A1))))
adjust ranges to suit (note: It is highly recommended that you limit the range to as small a defined range as possible...if you use whole column, you may crash).
Then confirm the formula with CTRL+SHIFT+ENTER and not just ENTER and copy down.
Bookmarks