title: Google Sheets Merge many ranges into a single range
body: <p>There's this formula that merges two ranges:</p>
  <pre><code>=SORT(UNIQUE(FILTER(FLATTEN({IF(COUNTIFS( C3:C14 ; C3:C14 ;ROW(C3:C14);&quot;&lt;=&quot;&amp;ROW(C3:C14))=1;C3:C14;&quot;&quot;); D3:D14});FLATTEN({IF(COUNTIFS( C3:C14 ; C3:C14 ;ROW(C3:C14);&quot;&lt;=&quot;&amp;ROW(C3:C14))=1;C3:C14;&quot;&quot;); D3:D14})&lt;&gt;&quot;&quot;));1;TRUE)
  </code></pre>
  <p>Which Merges the ranges (<code>C3:C14</code> and <code>D3:D14</code>) into a single column, then it filters blank cells, removes duplicates and then sorts values in ascending order.</p>
  <p>Is there an easier/lighter way to merge many ranges into a single range while ignoring blanks and duplicates? In my case I need to merge from <code>C3</code> to <code>H14</code> which makes 6 columns. Thank you in advance for the help.</p>