title: ArrayFormula retrieve list by multiple criterias
body: <h1>Input</h1>
  
  <p><strong>Data sheet</strong></p>
  
  <pre><code>TaskId  ClientId Canceled
  1             1         0
  2             1         0
  3             1         0
  4             2         0
  5             2         1
  6             2         0
  7             3         0
  </code></pre>
  
  <p><strong>Report sheet</strong></p>
  
  <pre><code>ClientId
  1
  1
  2
  3
  </code></pre>
  
  <h1>Desired Output</h1>
  
  <p>Arrayformula to get all TaskIds from Data by clients where Canceled = 0</p>
  
  <pre><code>TaskIds
  1
  2
  3
  1
  2
  3
  4
  6
  7
  </code></pre>
  
  <hr>
  
  <p>I have <code>join</code> + <code>filter</code> formula to drag down, which gives me all TaskIds for clients:</p>
  
  <pre><code>ClientId  TaskIds
  1          1,2,3
  1          1,2,3
  2          4,6
  3          7
  </code></pre>
  
  <p>Then I get my result from this helper_column:</p>
  
  <p><code>=transpose(split(join(",", helper_colum)))</code></p>
  
  <p>And I want to make this work without need to drag down.</p>