SQL> ed
Wrote file afiedt.buf

  1  with t as (
  2  select 36 n_h,56 n_c,4774 b from dual union all
  3  select 36 n_h,54 n_c,300 b from dual union all
  4  select 36 n_h,45 n_c,812 b from dual union all
  5  select 38 n_h,54 n_c,5885 b from dual
  6  )
  7  select
  8   n_h "номер-дома"
  9  ,nvl("баланс-56",0) "баланс-56"
 10  ,nvl("баланс-54",0) "баланс-54"
 11  ,nvl("баланс-45",0) "баланс-45"
 12  from t
 13  pivot (sum(b) for n_c in (56 as "баланс-56",54 as "баланс-54",45 as "баланс-45"))
 14* order by 1
SQL> /

номер-дома  баланс-56  баланс-54  баланс-45
---------- ---------- ---------- ----------
        36       4774        300        812
        38          0       5885          0