SQL & PL/SQL

DB:9I

with T as(

SELECT 1 ID, 'A' data1, 'D'  data2, 'B' data3, 'A' data4 FROM dual UNION ALL

                  SELECT 2 ID, 'C' data1, 'H' data2, 'Q' data3, 'C' data4 FROM dual)

                  select * from T

I wish Result

ID      Date    Values

1            data1      A

1            data2      D

1            data3      B

1            data4      A

2            data1      C

2            data2      H

2            data3      Q

2            data4      C