Trying to convert the row value to column (PIVOT) of the given table.
S.No ID Column2 Column3
1 1 1 Firstname
2 1 2 MiddleName
3 1 14 ContactNumber
4 2 1 Firstname
5 2 14 ContactNumber
6 3 14 ContactNumber
7 3 2 MiddleName
I want like below for ID 1
Clumn2 1 2 14
Column3 FirstName MiddleName LastName
please help me to solve it. Thanks
Aucun commentaire:
Enregistrer un commentaire