title: How to include Column K != null condition in google-apps-script?
body: <p>I have a code that copy pastes data from one sheet to another workbook whenever I run it. However, I only want specific data to copy from the original sheet where column K is not null. Could someone help recommend how I can incorporate that in my code?</p>
  
  <p>Thanks in advance!</p>
  
  <pre><code>function transferList() 
  {
     var sourceSheet = 
  SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Colombo");
   var sourceData = sourceSheet.getDataRange().getValues();
   sourceData.splice(0,1);  // Remove header
   var targetSS = . 
  SpreadsheetApp.openById("TargetSheetID").getSheetByName("Tester");
    var targetRangeTop = targetSS.getLastRow(); // Get # rows currently in target
   targetSS.getRange(targetRangeTop+1,1,sourceData.length,sourceData[0].length).setValues(sourceData);
  
  } 
  </code></pre>