with t as (
SELECT 'apple' a, '100' b, '10' c FROM DUAL UNION ALL
SELECT 'samsung', '200', '20' FROM DUAL UNION ALL
SELECT 'lg', '300', '30' FROM DUAL
)
select "1", "2", "3", "4"
  from
      (select rn, ln,
              decode(ln,1,a,2,b,3,c) val
         from
             (select rownum rn, a, b, c
                from t) a,
             (select level ln from dual connect by level <= 3) b
        order by rn, ln)
pivot
( min(val) for rn in (1,2,3,4) )