title: ImportRange Function to Ignore Empty Cells
body: <p>I want to import a range from another Google sheet, but to ignore empty cells so that the data prints back to back (versus having big gaps created from importing empty cells). Here is my formula (Google link changed for confidentiality):</p>
  
  <pre><code>=IMPORTRANGE("https://docs.google.com/spreadsheets/d/dalsfjasfdjjasfd/edit#gid=76574001",
   "Course_Schedule!F2:F77")
  </code></pre>
  
  <p><strong>Put another way, import range of about result would be:</strong>
  blank cell,
  blank cell,
  25,
  43,
  blank cell</p>
  
  <p><strong>When I want it to be:</strong>
  25,
  43</p>