Yes. I want only one column as the output. And the condition for the output is the <blank> value in one of the columns. In my table, only one column (AgencyFrom or AgencyTo) hold <blank> data per row. Both do not hold <blank> together.

Does this make sense?