title: How to merge two rows in R?
body: <p>I wanted to know if there is a function in R that will help me merge two rows. Right now my data is in the following shape</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Car_Type</th>
  <th>Prod</th>
  <th>Sale</th>
  <th>Month</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Civic</td>
  <td>120</td>
  <td>67</td>
  <td>June</td>
  </tr>
  <tr>
  <td>City</td>
  <td>192</td>
  <td>112</td>
  <td>June</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>If possible, I would like the data to take this shape:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Car_Type</th>
  <th>Prod</th>
  <th>Sale</th>
  <th>Month</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Civic + City</td>
  <td>312</td>
  <td>179</td>
  <td>June</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I have tried the aggregate function, which works, but it does not manipulate the entire data frame.</p>
  <p>Any leads would be appreciated. Thanks!</p>