 <p>If you have only one value for each key for each user:</p> <pre><code>select P.* from Table1 as t pivot ( max(Value) for [Key] in ([Address], [Number], [Sport], [Document]) ) as P </code></pre> <p>or</p> <pre><code>select t.Usr, max(case when t.[Key] = 'Address' then t.[Value] end) as Address, max(case when t.[Key] = 'Number' then t.[Value] end) as Number, max(case when t.[Key] = 'Sport' then t.[Value] end) as Sport, max(case when t.[Key] = 'Document' then t.[Value] end) as Document from Table1 as t group by t.Usr </code></pre> <p><strong><kbd><a href="http://sqlfiddle.com/#!3/cd68cc/4" rel="nofollow">sql fiddle demo</a></kbd></strong></p>