Cacher is the code snippet organizer for pro developers

  range.getValues().forEach(function(arr, idx, mat){
    if(arr[0] == ''){
      range.splice(idx);
    } else {
      retNameDict[arr[0]] = {name: arr[1], mailAddress: arr[2]};    
    }
  });