If you are just trying to filter out errors then this should work fine:
=FILTER(MyDatatable; ISERROR(MyDatatable[column2])=FALSE)