title: Google Sheets: How do I create an array from a range, adding a column with a constant literal value in every row?
body: <p>I want to make an array with several columns. The second and subsequent columns are specified as a range pulled from another sheet. The first column is a static constant, that is, every cell in the first column should have the very same literal string value, say 'foo'. I can't find the correct syntax. I'd have thought something like this would work:</p>
  <p>={&quot;foo&quot;, 'Other Sheet'!C2:F}</p>
  <p>but I get &quot;Function ARRAY_ROW parameter 2 has mismatched row size. Expected: 1. Actual: 999.&quot; Clearly &quot;foo&quot; needs to be &quot;expanded&quot; to a column with lots of rows. How do I do it, and where are tricks like this documented?</p>
  <p>Maybe the answer to this question would give a start: How do I create an array containing a single column, every cell containing &quot;foo&quot;, with the number of columns specified by a different range?</p>
  <p>Here is an editable sheet illustrating the problem and the desired solution:
  <a href="https://docs.google.com/spreadsheets/d/17myzKVFN3SDQuubWNdP-dFAbdvdlRbZFkjRpLi2Fas8/edit?usp=sharing" rel="noreferrer">https://docs.google.com/spreadsheets/d/17myzKVFN3SDQuubWNdP-dFAbdvdlRbZFkjRpLi2Fas8/edit?usp=sharing</a>
  The exact question is this: what formula can I put in cell B9 of Sheet1 to get the current appearance of Sheet1? Notice that I don't know in advance how many rows there are in 'Other Sheet'. It's OK to assume that all rows of Other Sheet have a nonblank value in column C.</p>