By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table table1
(
id int,
type varchar(10),
data varchar(10)
)
insert into table1 values
( 1 , 'Name' , 'John'),
( 1 , 'Gender' , 'Male'),
( 1 , 'Code' , '1782'),
( 2 , 'Name' , 'Dave'),
( 2 , 'Gender' , 'Male');
5 rows affected
select *
from table1
pivot
(
max(data)
for type in ([Name], [Gender], [Code])
)p
| id | Name | Gender | Code |
|---|---|---|---|
| 1 | John | Male | 1782 |
| 2 | Dave | Male | null |