Edit in JSFiddle

$(document).ready(function() {
   var table = $('#example').DataTable({
      'ajax': 'https://api.myjson.com/bins/pr6dp',
      'columnDefs': [
         {
            'targets': [1, 2, 3, 4, 5],
            'orderable': false,
            'searchable': false
         }
      ],
      'rowsGroup': [0],
      'createdRow': function(row, data, dataIndex){
         // Use empty value in the "Office" column
         // as an indication that grouping with COLSPAN is needed
         if(data[2] === ''){
            // Add COLSPAN attribute
            $('td:eq(1)', row).attr('colspan', 5);

            // Hide required number of columns
            // next to the cell with COLSPAN attribute
            $('td:eq(2)', row).css('display', 'none');
            $('td:eq(3)', row).css('display', 'none');
            $('td:eq(4)', row).css('display', 'none');
            $('td:eq(5)', row).css('display', 'none');
         }
      }      
   });   
});
<h3><a href="http://www.gyrocode.com/articles/jquery-datatables-colspan-in-table-body-tbody/">jQuery DataTables: COLSPAN in table body TBODY</a> <small>COLSPAN and ROWSPAN</small></h3>
    
<table id="example" class="stripe hover cell-border order-column" cellspacing="0" width="100%">
   <thead>
      <tr>
         <th>Name</th>
         <th>Position</th>
         <th>Office</th>
         <th>Extn.</th>
         <th>Start date</th>
         <th>Salary</th>
      </tr>
   </thead>
   <tfoot>
      <tr>
         <th>Name</th>
         <th>Position</th>
         <th>Office</th>
         <th>Extn.</th>
         <th>Start date</th>
         <th>Salary</th>
      </tr>
   </tfoot>
</table>

External resources loaded into this fiddle: