Attempting to create a query that will return all rows except the two rows noted in the screenshot below. The goal, in essence, is to ensure at least one row is returned for each ID value and at the same time remove rows where data1 is blank or nul. Hopefully, this makes sense.
If ID contains a duplicate value and one of its associated data1 values is blank or null, then don't return the row where data1 is blank or null.
If ID contains a duplicate value and all of its associated data1 values are blank or null, then return one of the rows where data 1 is blank or null.