title: How to insert rows on sheet 2 upon value change on sheet 1
body: <p>I have a list of states that have statuses on sheet 1.
  I'm basically trying to get data from Sheet 1, to populate onto Sheet 2 based on certain criteria. For example, If the status on Sheet 1 changes to ‘G’ on any of the states, I'm trying to get the entire row to populate into the table on Sheet 2. I'm looking to have a running table on sheet 2, so as we add information onto sheet 1, it automatically shows the breakdown of criteria on sheet 2.</p>
  
  <p>It should repopulate sheet 2 with new breakdowns every time I run the script</p>
  
  <p>eg.</p>
  
  <h2>Sheet 1</h2>
  
  <p>States    status</p>
  
  <p>CA        G</p>
  
  <p>TX        IP</p>
  
  <h2>Sheet 2</h2>
  
  <p>States in G</p>
  
  <p>CA     G</p>
  
  <p>States in IP</p>
  
  <p>TX     IP</p>