How to create a table for this one.

AAA BBB CCC
RED 1 2 3
BLUE 4 5 6
GREEN 7 8 9

I tried on SQL DEVELOPER.It's gave me an error.

And converted into an out put like..

RED BLUE GREEN
AAA 1 4 7
BBB 2 5 8
CCC 3 6 9.........(For this we will use Listagg or Pivot Key word.)

SQL>SELECT LISTAGG(RED,BLUE,GREEN ', ') WITHIN GROUP (ORDER BY COLNAMES) "CONVERT"
FROM CNVT;

OR...By using Pivot_Key word.

Note:-which one is better to do a sol.