title: How to FILTER rows that are not blank?
body: <p>I have a Google sheet where I am transposing unique values from a data range and displaying them. I only want to include values from rows in column A when the row in column B is <code>NOT</code> blank. I've tried using:</p>
  
  <pre><code>=not(isblank(A:A)) 
  </code></pre>
  
  <p>but it didn't work. If possible I want to fit in the function format I already have:</p>
  
  <pre><code>=transpose(unique(filter(A:A,(B:B= ....)
  </code></pre>