javascript - html table row column spliting

Question

I have tried to conter the html table below into the table in the image below

In new new table I want to use rowspan col span to simulate excel sheet format

<table class="table" id="view_statusTable">
  <thead class="fully" style="display: none;" hidden="">
    <tr>
      <th>Filename</th>
      <th>File Prefix</th>
      <th>Total Transactions</th>
      <th>Valid Transactions</th>
      <th>Invalid Transactions</th>
      <th>Status</th>
    </tr>
  </thead>
  <thead class="partially" style="display: table-header-group;" hidden="">
    <tr>
      <th>Filename</th>
      <th>File Prefix</th>
      <th>Total</th>
      <th>Valid</th>
      <th>Invalid</th>
      <th>Corrected</th>
    </tr>
  </thead>
  <tbody>
    <tr file_name="PVAL-14122020.xlsx" trans_type="Purchase" format_name="Purchase PVAL">
      <td>
        PVAL-14122020.xlsx
      </td>
      <td>
        PVAL
      </td>
      <td style="font-weight:bold">
        108
      </td>
      <td class="link valid_link " style="color:#5cb85c" index="1">
        65
      </td>
      <td class="link invalid_link " style="color:#d9534f" index="1">
        43
        <span class="spinner spinner-0" style="display:none;"></span>
      </td>
      <td index="1" class="link corrected_link link_hide">
        0
      </td>
    </tr>

    <tr file_name="SMAS-14122020.xlsx" trans_type="Sales" format_name="Sales SMAS">
      <td>
        SMAS-14122020.xlsx
      </td>
      <td>
        SMAS
      </td>
      <td style="font-weight:bold">
        112
      </td>
      <td class="link valid_link " style="color:#5cb85c" index="2">
        41
      </td>
      <td class="link invalid_link " style="color:#d9534f" index="2">
        71
        <span class="spinner spinner-1" style="display:none;"></span>
      </td>
      <td index="2" class="link corrected_link link_hide">
        0
      </td>
    </tr>

    <tr file_name="JRN-202012101030.xlsx" trans_type="Journal" format_name="undefined">
      <td>
        JRN-202012101030.xlsx
      </td>
      <td>
        JRN
      </td>
      <td style="font-weight:bold">
        32
      </td>
      <td class="link valid_link " style="color:#5cb85c" index="3">
        32
      </td>
      <td class="link invalid_link link_hide" style="color:#d9534f" index="3">
        0
        <span class="spinner spinner-2" style="display:none;"></span>
      </td>
      <td index="3" class="link corrected_link link_hide">
        -
      </td>
    </tr>
  </tbody>
</table>

question from:https://stackoverflow.com/questions/65919772/html-table-row-column-spliting

Answer 1

Waitting for answers