CREATE TABLE TEST(col1,col2)AS
(
SELECT 'AGE','24' FROM DUAL UNION ALL
SELECT 'NAME','JOHN' FROM DUAL UNION ALL
SELECT 'STATUS','SINGLE' FROM DUAL
)
SELECT MAX(col2),
MAX(CASE WHEN col1 = 'AGE' THEN 'AGE' END) AS AGE,
MAX(CASE WHEN col1 = 'NAME' THEN 'NAME' END) AS F_NAME,
MAX(CASE WHEN col1 = 'STATUS' THEN 'STATUS' END) AS S_STATUS
FROM TEST --group by value