title: Automatic merging of duplicate cells in google docs
body: <p>I have a sorted section of my spreadsheet and am trying to take it from</p>
  
  <pre><code>Name1 C32 5000
  Name1 C28 2500
  Name1 C72 900
  Name2 C540 500
  Name2 C320 900
  Name3 C28 2500
  Name3 C32 900
  </code></pre>
  
  <p>to</p>
  
  <pre><code>Name1 C32 5000
        C28 2500
        C72 900
  Name2 C540 500
        C320 900
  Name3 C28 2500
        C32 900
  </code></pre>
  
  <p>The area is always changing in size depending on what product the names have and the quantity they have. As well as how many names there are. The ideal solution would be for the extra duplicate names to be erased for viewing purposes automatically.</p>
  
  <p>Thanks for the help.</p>