Hiding columns with colspans in heading

colinod

I have a table that i am trying to use colvis button on but i have a rowspan on the column heading i am trying to hise.

This is a smaller example of what i have the actual table has 50 columns of the main headings with fails and score under each.

I want the colvis to use the main heading for the buttons but when i use it is all i get is lots of fails and scores?

can anyone help with this

thanks

<table id="example" class="display compact" style="width:100;" cellspacing="0">
~~~~
<thead>
    <tr>
    <th rowspan="2" style="border-left:1px solid #111;border-top:1px solid #111">NAME</th>
        <th rowspan="2" style="border-top:1px solid #111">COMPANY</th>
        <th rowspan="2" style="border-top:1px solid #111">LAST LOGIN</th>
        <th rowspan="2" style="border-top:1px solid #111">E-MAIL</th>
        <th rowspan="2" style="border-right:3px solid #111;border-top:1px solid #111">DIR/IND</th>
            
            <th colspan="2"  style="border-right:1px solid #111;border-top:1px solid #111">AR-5516/N / AR-5520/N</th>
            
            <th colspan="2"  style="border-right:1px solid #111;border-top:1px solid #111">AR-5623/D/N / AR-5620/D/N / AR-5618/D/N</th>
            
            <th colspan="2"  style="border-right:1px solid #111;border-top:1px solid #111">AR-6023D / AR-6020D</th>
            
            <th colspan="2"  style="border-right:1px solid #111;border-top:1px solid #111">AR-6023N / AR-6020N</th>
            
            <th colspan="2"  style="border-right:1px solid #111;border-top:1px solid #111">AR-6023N / AR-6020N / AR-6023D / AR-6020D / AR-6020</th>
</tr>

 <tr>
        
        
        


        <th>FAILS</th>
        <th  style="border-right:1px solid #111">SCORE</th>
        
        


        <th>FAILS</th>
        <th  style="border-right:1px solid #111">SCORE</th>
        
        


        <th>FAILS</th>
        <th  style="border-right:1px solid #111">SCORE</th>
        
        


        <th>FAILS</th>
        <th  style="border-right:1px solid #111">SCORE</th>
        
        


        <th>FAILS</th>
        <th  style="border-right:1px solid #111">SCORE</th>
</tr>
</thead>