title: Import Range from spreadsheet but exclude rows with missing data
body: <p>I have 2 spreadsheets (sheet1 + sheet2)</p>
  
  <p>Sheet2 Pulls in data from Sheet1 using the IMPORTRANGE function which works fine, except that there are a few rows that have missing information in 1-2 columns and for the purpose of what I am trying to do I need to just remove these rows.</p>
  
  <p>Can anyone point me in the right direction? Not sure if I need to add something to the IMPORTRANGE function or create a new spreadsheet and use a different function or do I have to manually delete these rows?</p>
  
  <p>Cheers</p>