Thanks for the create scripts !
Code:
SQL> select col1 val,
2 max(decode(col2, 'Option1', col3)) Option1,
3 max(decode(col2, 'Option2', col3)) Option2,
4 max(decode(col2, 'Option3', col3)) Option3,
5 max(decode(col2, 'Option4', col3)) Option4,
6 max(decode(col2, 'Option5', col3)) Option5
7 from temp1
8 group by col1
9 order by 1;
VAL OPTION1 OPTION2 OPTION3 OPTION4 OPTION5
---------- ---------- ---------- ---------- ---------- ----------
1 Val1 Val2 Val3 Val4 Val5
2 Val6 Val7 Val8
3 Val9 Val10 Val11 Val12