UnPivot is used to convert columns into rows.
We have below mentioned table who columns we want to convert into rows.
select PlayerName,Tournament,TotalScore
from TournamentScore
unpivot
(
TotalScore
for
Tournament in ([UTU],[Zonal])
) as UnPivotex
using Saillesh.Pawar; 