title: How to Convert Row to Column in Linq and SQL
body: <p>i have a table called <strong>Languagemaster</strong> having below record </p>
  
  <pre><code>language keyName keyValue
  English    City    AA
  Swedish    City    AAswedish
  German     City    AAger
  Chines     City    AAchines
  French     City    AAfr
  Spanish    City    AAspanish
  </code></pre>
  
  <p>how to convert <strong>Languagemaster</strong> Table to below table</p>
  
  <pre><code>keyName  English Swedish   German  Chines   French  Spanish            
  City      AA     AAswedish AAger   AAchines AAfr    AAspanish
  </code></pre>
  
  <p>please let me know how to write Query in both  SOL and LinQ.</p>