title: Reduce a range of values to a list in Google Sheets
body: <p>I have a table with printer names and the model numbers of the toner and drums which they use. I'm looking for a way to generate a single column list from this range of values, excluding blank cells. Below is the table:</p>
  
  <p><a href="https://i.stack.imgur.com/sKri5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/sKri5.png" alt="enter image description here"></a></p>
  
  <p>I'd like to end up with a list of values as such:</p>
  
  <pre><code>MX-C30NT-B
  MX-C30NT-C
  MX-C30NT-M
  MX-C30NT-Y
  MX-C30DR
  MX-C30HB
  MX-C30NV-B
  MX-C30NV-C
  MX-C30NV-M
  MX-C30NV-Y
  ...
  </code></pre>
  
  <p>I know in Excel I can use an array formula to accomplish this, but array formulas don't seem to be as robust in Sheets. Is there a formula which will perform this conversion?</p>