Sql convert data into one row from multiple columns

Question

I have a table

enter image description here

and I want to convert it into one row for each customer number something like this:

enter image description here

Can someone point me to the right place , example where I can do similar thing.

The key term you are looking for is 'pivot'. I'm short on time now, but I can provide a solution later today if nobody beats me to it. — Twelfth
– Twelfth, Commented Feb 26, 2014 at 17:20

user2989408 · Accepted Answer · 2014-02-26 17:14:56Z

1

You need to use PIVOT. Something like the following query should help.

SELECT CustomerNumber, 
    CASE WHEN [1] > 0 THEN 'Y' ELSE 'N' END [Sony],
    CASE WHEN [2] > 0 THEN 'Y' ELSE 'N' END [LG],
    CASE WHEN [3] > 0 THEN 'Y' ELSE 'N' END [Samsung]
FROM
(SELECT Product1, CustomerNumber
    FROM Table) AS SourceTable
PIVOT
(
    COUNT(Product1)
    FOR Product1 IN ([1], [2], [3])
) AS PivotTable;

answered Feb 26, 2014 at 17:14

user2989408

3,1371 gold badge20 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sql convert data into one row from multiple columns

1 Answer 1

Comments

Your Answer

Linked

Collectives™ on Stack Overflow

Sql convert data into one row from multiple columns

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related