title: Table sorting with two rows of Header
body: <p>My Table structure is like below:</p>
  
  <p><img src="https://i.stack.imgur.com/YCRHf.png" alt="enter image description here"></p>
  
  <p>This is my HTML:</p>
  
  <pre><code>&lt;table id="jackpotwatch" style="width:700px;"&gt;
          &lt;thead&gt;
            &lt;tr&gt;
  
                &lt;th&gt;Location&lt;/th&gt;
                &lt;th colspan="2"&gt;Full Name&lt;/th&gt;
                &lt;th&gt;Amount&lt;/th&gt;
  
            &lt;/tr&gt;
            &lt;tr &gt;
              &lt;th&gt;Asset&lt;/th&gt;
              &lt;th&gt;Patron ID&lt;/th&gt;
              &lt;th&gt;User&lt;/th&gt;
              &lt;th&gt;Date/Time&lt;/th&gt;
            &lt;/tr&gt;
          &lt;/thead&gt;
          &lt;tbody&gt;
             &lt;tr&gt;
                &lt;td&gt;Salem&lt;/td&gt;
                &lt;td colspan="2"&gt;Bob galvin&lt;/td&gt;
                &lt;td&gt;$3400&lt;/td&gt;
             &lt;/tr&gt;
             &lt;tr&gt;
               &lt;td&gt;assert1&lt;/td&gt;
               &lt;td&gt;1148&lt;/td&gt;
               &lt;td&gt;sjauser&lt;/td&gt;
               &lt;td&gt;11/12 10:39 AM&lt;/td&gt;
             &lt;/tr&gt;
             &lt;tr&gt;
                &lt;td&gt;chennai&lt;/td&gt;
                &lt;td colspan="2"&gt;sally n safer&lt;/td&gt;
                &lt;td&gt;$400&lt;/td&gt;
             &lt;/tr&gt;
             &lt;tr&gt;
               &lt;td&gt;sdfsdgt1&lt;/td&gt;
               &lt;td&gt;4747&lt;/td&gt;
               &lt;td&gt;sjauser&lt;/td&gt;
               &lt;td&gt;11/12 10:39 AM&lt;/td&gt;
             &lt;/tr&gt;
             &lt;tr&gt;
                &lt;td&gt;Mazdgfdg&lt;/td&gt;
                &lt;td colspan="2"&gt;afdagadg&lt;/td&gt;
                &lt;td&gt;789769&lt;/td&gt;
             &lt;/tr&gt;
             &lt;tr&gt;
               &lt;td&gt;qwqeqe&lt;/td&gt;
               &lt;td&gt;47467&lt;/td&gt;
               &lt;td&gt;sjauser&lt;/td&gt;
               &lt;td&gt;11/12 10:39 AM&lt;/td&gt;
             &lt;/tr&gt;
             &lt;tr&gt;
                &lt;td&gt;hurtyry&lt;/td&gt;
                &lt;td colspan="2"&gt;afadfadg&lt;/td&gt;
                &lt;td&gt;$12000&lt;/td&gt;
             &lt;/tr&gt;
             &lt;tr&gt;
               &lt;td&gt;afadsf&lt;/td&gt;
               &lt;td&gt;25426546&lt;/td&gt;
               &lt;td&gt;sjauser&lt;/td&gt;
               &lt;td&gt;11/12 10:39 AM&lt;/td&gt;
             &lt;/tr&gt;
          &lt;/tbody&gt;
          &lt;/table&gt;
  </code></pre>
  
  <p>When i click on the "Amount" header the amount values ($3400, $400, $12000) should be sorted, etc.
  Like that Date/Time field also should sort based on the value. </p>
  
  <p>I used <a href="http://tablesorter.com/docs/" rel="nofollow noreferrer">Tablesorter</a> plugin but that plugin not sorting all columns. It not sorting last column and second row header in this table. 
  I also used <a href="http://tinysort.sjeiti.com/" rel="nofollow noreferrer">Tinysort</a> plugin but it change the table structure itself while sorting. </p>
  
  <p>I cannot able to change the table structure as this is our client biggest requirement. Please provide some guide on this sorting problem which is very useful for me.</p>
  
  <p>Any customized sorting we can apply means please suggest how can i do that.</p>