title: Group Rows with different values and rename it
body: <p>How do I group the group rows that have different value and rename it, while summing other columns. </p>
  
  <pre><code>|  Dept  |  Value 1  | Value 2  |  Value 3  |
  
  |  Car1  |  2        |  4       |  9        |
  
  |  Car2  |  2        |  8       |  9        |
  
  |  Car3  |  1      |  4       |  9        |
  
  |  MC1  |  2        |  4       |  9        |
  
  |  MC2  |  2        |  7       |  9        |
  
  |  MC3  |  2        |  4       |  9        |
  
  |  RV1  |  2        |  4       |  5        |
  
  |  RV2  |  2        |  34       |  9        |
  
  |  RV3  |  3        |  4       |  9        |
  </code></pre>
  
  <p>I want to group car1, car2, car3, into a single row named Car, MC1, MC2, MC3 into a single row name Motorcycle, and RV1, RV2, RV3 into a single row named RV. The columns "value1, value 2, and value 3" are summed as for each group.</p>