Skip to content
Advertisement

Pivot some row values to a columns

I am trying to pivot some row values to a column, below is what I am trying to achieve.

My Current Schema:

This is what I am trying to achieve:

but it skips rows when name and lan have similar values, in this case it skips the row with the name value vsp.

Advertisement

Answer

this fixes my problem.

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