How do I pivot table data

Question

My table structure is as below:

Person_id      Add_Type        Address
1              Present         A
1              Permanent       B

I want pivot table as below:

Person_id      Present       Permanent
1                A             B

Possible duplicate of [Convert Rows to columns using 'Pivot' in SQL Server](http://stackoverflow.com/questions/15931607/convert-rows-to-columns-using-pivot-in-sql-server) — Shnugo, Apr 29 '16 at 07:39

Stanislovas Kalašnikovas · Accepted Answer · 2016-04-29T07:41:40.697

First at all try to use any search engine... This is what you need:

SAMPLE DATA

create table #t
(
   Person_id VARCHAR(MAX),
   Add_Type VARCHAR(MAX),
   Address_ VARCHAR(MAX)
)
insert into #t values ('1','Present', 'A'), ('1','Permanent', 'B')

QUERY

select *
from (select Person_id, Add_Type, Address_ 
      from #t 
      )as src
pivot
(
   min(Address_)
   for Add_Type in ([Present], [Permanent])
) as pvt

OUTPUT

Person_id      Present       Permanent
1              A             B

How do I pivot table data

1 Answers1