title: Pivot query assistance
body: <pre><code>Job Batch id   Company Outlet Id   Clearance required   Hanky required 
  1              10                  T                    T
  </code></pre>
  
  <p>Now I want the the following </p>
  
  <pre><code>Job Batch id   Company Outlet ID    Reason    
  1              10                   Clearance Required , Hanky Required 
  </code></pre>
  
  <p>My brain has frozen so was needing assistance ?</p>
  
  <p>How to construct this unpivot query ?</p>