title: Replace original rows with duplicate rows then remove duplicates
body: <p>I have a dataframe similar to </p>
  
  <pre><code>    Name   Value  Value2
       A       1      11        
       B       2      12
       C       3      13
       A       4      14
       B       5      15
  
  </code></pre>
  
  <p>I need to take the rows were Name is a duplicate and replace the rows with the first occurrence with the last occurrence and then remove the last duplicates. So in this example the output would be</p>
  
  <pre><code>    Name   Value  Value2
       A       4      14
       B       5      15
       C       3      13    
  </code></pre>
  
  <p>What would be a efficient way of doing this?         </p>