title: How can I increment counter when the value in another column changes?
body: <p>I have the following table</p>
  
  <pre><code>ID      
  12     
  12    
  25    
  25    
  78    
  78    
  78  
  </code></pre>
  
  <p>And I need to be able to increment the counter value when the <code>ID</code> changes. </p>
  
  <pre><code>ID    **COUNTER**  
  12     1
  12     1
  25     2
  25     2
  78     3
  78     3
  78     3
  </code></pre>
  
  <p>How can this be done? Is it even possible?</p>