C1 C2 C3
1 4 7
2 5 8
3 6 9
Expected result:
NEW_COL VALUE
C1 1
C2 4
C3 7
C1 2
C2 5
C3 8
C1 3
C2 6
C3 9
I Tried like below
SELECT 'C1' AS NEW_COL,C1 AS VALUE FROM TEST
UNION ALL
SELECT 'C2' AS NEW_COL,C2 AS VALUE FROM TEST
UNION ALL
SELECT 'C3' AS NEW_COL,C3 AS VALUE FROM TEST
NEW_COL VALUE
C1 1
C1 2
C1 3
C2 4
C2 5
C2 6
C3 7
C3 8
C3 9