Skip to content
Advertisement

MS SQL Convert rows to columns with Pivot

in MS SQL I have following table

source table

I would like to convert it to :

Destination table

I had a look at pivot table function, but could not get it work correctly. Any advice?

Advertisement

Answer

You coud try this:

enter image description here

User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement