Unnamed
public text v1 · immutablei m having an table "x"
it consists of
region product month1 month2 month3 month4 month5 month6 <--- columns
1 p1 100 90 60 50 48 46
2 p2 100 90 60 50 48 46
3 p3 100 90 60 50 48 46
4 p4 100 90 60 50 48 46
5 p5 100 90 60 50 48 46
i want to display this as
name values month
1 100 month1
p1 100 month1
1 90 month2
etc
ie i want to Cross tab it like this way
what is the query to do it