Multiple column pivot in sql server

Posted by Kirthiga under Sql Server on 5/31/2018 | Points: 10 | Views : 1187 | Status : [Member] | Replies : 0

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

How to arrive pivot table three columns side by side

Table
Prod Data Col A Col B Col C
A1 C1 5 2 2
B1 D1 4 3 4
A1 C1 6 4 6
A4 D1 5 3 3

Required Output
Prod D1 Col A D1 Col B D1 Col C D1 Col A D1 Col B D1 Col C
A1 11 6 8
A4 5 3 3
B1 4 3 4

Reply | Reply with Attachment

Alert Moderator

Responses

(No response found.)

Latest Posts

Iterating over columns of dataframe and print as rows in Python Django (0)
Where can I found sample MVC projects to learn and improve skills (1)
Extract a value from HTML string (0)
Get only year part from date string in SQL server (0)
Get only year part from date string in SQL server (0)
Get only year part from date string in SQL server (0)
Get only year part from date string in SQL server (0)
django.template.exceptions.TemplateDoesNotExist: AlgoDash/index.html (0)
More ...