title: How to find the non-blank value in column I in sheet1 then copy entire row and paste to sheet2
body: <p>I have data in Google sheet1 A:I, I need to copy the row from A:I if column J has value then paste to last row of sheet2. Thank for your help</p>
  <p>Exp: I want to copy 3 rows has dog, cat and mango to last row of sheet2</p>
  <p><img src="https://i.stack.imgur.com/YktS5.png" alt="enter image description here" /></p>
  <pre><code>datas   datas   datas   datas   datas   datas       
  datas   datas   datas   datas   datas   datas       dog
  datas   datas   datas   datas   datas   datas       cat
  datas   datas   datas   datas   datas   datas       mango
  datas   datas   datas   datas   datas   datas       
  </code></pre>