title: Google sheet arrayformula join() and split() functions
body: <p>Does anybody know how to arrayformula this <code>join</code> function? </p>
  
  <p>My formula is not as complex as the example here. <a href="https://stackoverflow.com/questions/14433945/how-do-i-convert-this-formula-into-an-arrayformula-google-spreadsheets">ArrayFormula a Filter in a Join (Google Spreadsheets)</a></p>
  
  <p>It does not contain a <code>filter</code> function, so I'm not sure what from that answer applies and doesn't apply.</p>
  
  <p>I want to array formula this: <code>=if(isblank(B2),,join("," ,B2:I2))</code></p>
  
  <p>Using the normal way to array something doesn't work:</p>
  
  <p><code>=ArrayFormula(if(isblank(B2:b),,join(",",B2:b:I2:i)))</code></p>
  
  <p>Also for splits, I have <code>split(B2, ",")</code></p>
  
  <p><code>=ArrayFormula(split(B2:B,","))</code> does nothing but the first row</p>