scott@ORA92> select * from your_table
  2  /

      COL1       COL2       COL3 COL4  COL5
---------- ---------- ---------- ----- ------
      2005       2004       2003 area1 brand1

scott@ORA92> select col1 as col1, col4 as col2, col5 as col3
  2  from   your_table
  3  union all
  4  select col2 as col1, col4 as col2, col5 as col3
  5  from   your_table
  6  union all
  7  select col3 as col1, col4 as col2, col5 as col3
  8  from   your_table
  9  order  by col1 desc
 10  /

      COL1 COL2  COL3
---------- ----- ------
      2005 area1 brand1
      2004 area1 brand1
      2003 area1 brand1

scott@ORA92>