title: Merging select consecutive rows in a data frame
body: <p>I have a data set of the following format</p>
  <pre><code>    ID 12345
      NAME JohnDoe
      INFO Info about the individual
      INFO Extra info about the individual
  
      ID 12346
      NAME JaneDoe
      INFO Info about the individual
  
      ID 12347
      NAME JohnSmith
      INFO Info about the individual
  </code></pre>
  <p>Right now I have a data frame that looks like this:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Column 1</th>
  <th>Column 2</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>ID.</td>
  <td>12345</td>
  </tr>
  <tr>
  <td>Name.</td>
  <td>JohnDoe</td>
  </tr>
  <tr>
  <td>Info</td>
  <td>Info about the individual</td>
  </tr>
  <tr>
  <td>Info</td>
  <td>Extra info about the individual</td>
  </tr>
  <tr>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>ID.</td>
  <td>12346</td>
  </tr>
  <tr>
  <td>Name.</td>
  <td>JaneDoe</td>
  </tr>
  <tr>
  <td>Info</td>
  <td>Info about the individual</td>
  </tr>
  <tr>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>ID.</td>
  <td>12347</td>
  </tr>
  <tr>
  <td>Name.</td>
  <td>JohnSmith</td>
  </tr>
  <tr>
  <td>Info</td>
  <td>Info about the individual.</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Where an ID and Name can have one or more associated pieces of information and entire items are separated by a blank row.</p>
  <p>And I want to create a table that looks like:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>ID.</th>
  <th>Name.</th>
  <th>Info.</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>12345</td>
  <td>JohnDoe</td>
  <td>Info about the individual, extra info...</td>
  </tr>
  <tr>
  <td>12346</td>
  <td>JaneDoe</td>
  <td>Info about the individual.</td>
  </tr>
  <tr>
  <td>12347</td>
  <td>JohnSmith</td>
  <td>Info about the individual.</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>So far I've been able to filter the first frame to create columns of IDs and Names, but how can I group separate infos into one string to create a column with the same number of rows as the other two?</p>