This question already has an answer here:

I have a table as follows:

Id  Movie_name   Person_Name    Role_Name
1      mov1           xyz         Singer
1      mov1           pqr         Dancer
1      mov1           abc         Actor
2      mov2           asd         Director
2      mov2           fgh         Producer

I need result like following

Id  Movie_name Person_Name Person_Name Person_Name Role_Name Role_Name Role_Name
1      mov1           xyz        pqr        abc     Singer    Dancer     Actor
2      mov2           asd        fgh                Director  Producer                          

Can anyone please help me out on this?

marked as duplicate by Paul White Feb 11 at 12:57

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

Browse other questions tagged or ask your own question.