Row Types into Columns with adjacent values into rows

Question

I have a long query which I'll summarize like:

SELECT Name, Type, Rev
From Table

It returns something like:

Name    Type    Checked
Bob     Grp1    Frank
Bob     Grp2    Frank
Bob     Grp3    Frank
Lisa    Grp1    Sarah
Lisa    Grp3    Sarah

Now, since I have up to 3 types, I'd like them to be their own columns and see the values in the 3rd column show up under each type:

For example:

Name   Grp1    Grp2    Grp3 
Bob    Frank   Frank   Frank
Lisa   Sarah   NULL    Sarah

Basically I'm looking for a query on how to do this. Any feedback would be appreciated.

Looks like you need to PIVOT https://learn.microsoft.com/en-us/sql/t-sql/queries/from-using-pivot-and-unpivot — cdsln, Aug 28 '17 at 15:29
Use [**PIVOT**](https://technet.microsoft.com/es-es/library/ms177410(v=sql.105).aspx) — Juan Carlos Oropeza, Aug 28 '17 at 15:29
Thanks for the quick feedback. Would it be possible to provide an example on how I can do that with my possible criteria? — kazzi, Aug 28 '17 at 15:31

John Cappelletti · Accepted Answer · 2017-08-28T15:43:22.120

2

Quick sample

Select *
 From  YourTable
 Pivot (max(Checked) for Type in ([Grp1],[Grp2],[Grp3])) P

Edit - If you have more than the displayed fields

Select *
 From  (
            SELECT Name, Type, Checked
            From Table
       ) A
 Pivot (max(Checked) for Type in ([Grp1],[Grp2],[Grp3])) P

edited Aug 28 '17 at 15:43

answered Aug 28 '17 at 15:33

John Cappelletti

79,615
7
44
66

Trying this out ^ – kazzi Aug 28 '17 at 15:34

Lamar · Answer 2 · 2017-08-28T22:32:51.113

1

I usually use CASE statement like this:

select Name,
case Type when 'Grp1' then checked else null end as 'Grp1',
case Type when 'Grp2' then checked else null end as 'Grp2',
case Type when 'Grp2' then checked else null end as 'Grp3'
from table

edited Aug 28 '17 at 22:32

answered Aug 28 '17 at 15:33

Lamar

1,761
4
24
50

Row Types into Columns with adjacent values into rows

2 Answers2