SELECT * FROM T T PIVOT ( MAX(COL3) FOR COL2 IN ('월계2동','전농2동','면목4동','평내동') ) ORDER BY COL1
원하는 결과가 나오는것 같은데 확인해보셔요~