title: how to read a csv file that has multiple lines within the same cell?
body: <p>I apologize in advance for the image - I don't know how else to represent multiple lines in a single cell in stackoverflow.</p>
  <p>I have a csv file that has multiple lines in a single cell like what is shown in table 1. I need each line, in each cell, to have its own column. Luckily each column has the same number of lines per cell. I.e. column-1 has 4 lines per row, column-2 has 2 lines per row, etc...</p>
  <p><a href="https://i.stack.imgur.com/mLCgt.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/mLCgt.png" alt="Table 1" /></a></p>
  <p>I would like the results to look like table 2 where each line has a column. I have been trying to do this with splitlines() without success.</p>
  <p>Table 2</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: left;">c1</th>
  <th style="text-align: left;">c2</th>
  <th style="text-align: left;">c3</th>
  <th style="text-align: left;">c4</th>
  <th style="text-align: left;">c5</th>
  <th style="text-align: left;">c6</th>
  <th style="text-align: left;">c7</th>
  <th style="text-align: left;">c8</th>
  <th style="text-align: left;">c9</th>
  <th style="text-align: left;">c10</th>
  <th style="text-align: left;">c11</th>
  <th style="text-align: left;">c12</th>
  <th style="text-align: left;">c13</th>
  <th style="text-align: left;">c14</th>
  <th style="text-align: left;">c15</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: left;">City of Pflugerville</td>
  <td style="text-align: left;">New Residential Permits</td>
  <td style="text-align: left;">1-1-2010 12:00:00 AM thru 3-6-2021 12:00:00 AM</td>
  <td style="text-align: left;">City</td>
  <td style="text-align: left;">13-23598</td>
  <td style="text-align: left;">6-11-2013 120000 AM</td>
  <td style="text-align: left;">Residential</td>
  <td style="text-align: left;">Residential Building</td>
  <td style="text-align: left;">1901 Meandering Meadows Dr</td>
  <td style="text-align: left;">Falcon Point Sec 4 South</td>
  <td style="text-align: left;">Ryland Homes</td>
  <td style="text-align: left;">1101 Arrow Point Dr. Ste. # 101 Cedar Park TX 78613</td>
  <td style="text-align: left;">208200</td>
  <td style="text-align: left;">Living - 2914 - Total - 3786.00</td>
  <td style="text-align: left;">Permits Issued in the City: 4573</td>
  </tr>
  <tr>
  <td style="text-align: left;">City of Pflugerville</td>
  <td style="text-align: left;">New Residential Permits</td>
  <td style="text-align: left;">1-1-2010 12:00:00 AM thru 3-6-2021 12:00:00 AM</td>
  <td style="text-align: left;">City</td>
  <td style="text-align: left;">13-23599</td>
  <td style="text-align: left;">6-11-2013 000</td>
  <td style="text-align: left;">Residential</td>
  <td style="text-align: left;">Residential Building</td>
  <td style="text-align: left;">3309 Pasqueflower Pass</td>
  <td style="text-align: left;">Falcon Pointe Sec 12</td>
  <td style="text-align: left;">Ryland Homes</td>
  <td style="text-align: left;">1101 Arrow Point Dr Cedar Park TX 78613</td>
  <td style="text-align: left;">267100</td>
  <td style="text-align: left;">Living - 3853 - Total - 4856.00</td>
  <td style="text-align: left;">Permits Issued in the City: 4573</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>If you can point me in the right direction I'd appreciate it.</p>