title: Excel - Remove duplicates and SUM at the same time
body: <p>I have a column with ID's, but they are duplicated; for instance:</p>
  
  <p>"0,0,1,1,1,2,3,3,4,4, ... "</p>
  
  <p>For each row, I have a given value in the other columns, for instance:</p>
  
  <p>"0-24; 0-36; 1-13; 1-34; 1-23;..."</p>
  
  <p>I want to keep only one row with each ID but I need to sum the values of each ID, that is, sum all the values in all columns for a given ID (0,1,2,...), which may include several rows.</p>
  
  <p>Is there a easy way to do this using Excel? </p>
  
  <p>Here is some sample data (table to the left) together with the desired output (tables to the right).</p>
  
  <pre><code>ID  Value           ID  Value
  0   24              0   60
  0   36              1   70
  1   13              2   16
  1   34              3   24
  1   23              4   48
  2   16                      
  3   9                       
  3   15                      
  4   24                      
  4   24      
  </code></pre>