title: Appending google spreadsheet arrays
body: <p>When I append arrays in google spreadsheets, all of the resulting elements are not rendered in cells.  For example, if I enter the formula:</p>
  
  <pre><code>={{1,2,3}, {4,5,6}}
  </code></pre>
  
  <p>the values rendered in spreadsheet cells are 1,4,5,6.  Any ideas about why this is happening, or alternatives?  My broader problem is to accumulate rows from separate sheets into another sheet - I can do that via </p>
  
  <pre><code>={ImportRange(...), ImportRange(...)}
  </code></pre>
  
  <p>but the same problem is apparent (missing the second element and beyond from the first array).</p>