title: How to create single list from two ranges in google sheets?
body: <p>In google sheet I have 2 ranges of variable length with some data,i.e.</p>
  
  <ul>
  <li><p>column A: aa, ab, ac;  and</p></li>
  <li><p>column B: ba, bb, bc.</p></li>
  </ul>
  
  <p>I would like to combine them in one long list in column C with a some formula:</p>
  
  <ul>
  <li>column C: aa, ab, ac, ba, bb, bc.</li>
  </ul>
  
  <p>I thought that UNIQUE function could work if it took 2 ranges- but it does not or ARRAYFORMULA but does not look like this is a sensible idea. </p>
  
  <p>So looking for solution or direction.</p>
  
  <p>Thank you!</p>
  
  <p>Marek</p>