title: Make a one line data to a table in SQL
body: <p>There is a record like</p>
  
  <pre><code>SWD Lead QA Lead PD Lead Business Manager
  AAAA     BBBB    CCCC    DDDD
  </code></pre>
  
  <p>I want to use T-SQL to get a result like below with the column name</p>
  
  <pre><code>SWD Lead         AAAA
  QA Lead          BBBB
  PD Lead          CCCC
  Business Manager DDDD
  </code></pre>
  
  <p>Does anyone know how to do it ?</p>
  
  <p>Best Regards,</p>