Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

with t1(file_, attrb1, attrb2, attrb3, attrb4) as (
    select 'F1', 0, 2, 4, 6 from dual union all
    select 'F1', 1, 3, 5, 7 from dual union all
    select 'F2', 7, 8, 9, 0 from dual union all
    select 'F2', 1, 2, 3, 4 from dual union all
    select 'F3', 0, 2, 0, 4 from dual union all
    select 'F3', 1, 0, 3, 0 from dual union all
    select 'F4', 3, 6, 9, 0 from dual union all
    select 'F4', 4, 8, 1, 2 from dual ), 
  t2(attrb_id, attrb_name, col, table_ref) as (
    select 1, 'WORDS',  'ATTRB1', 'T1' from dual union all
    select 2, 'CHARS',  'ATTRB2', 'T1' from dual union all
    select 3, 'MATCH',  'ATTRB3', 'T1' from dual union all
    select 4, 'SPACES', 'ATTRB4', 'T1' from dual )
select *
  from (
    select rn, file_, val, attrb_name
      from (select * from (select rownum rn, t1.* from t1) 
                           unpivot (val for attr in (ATTRB1, ATTRB2, ATTRB3, ATTRB4))) t1
      left join t2 on t2.col = t1.attr)
  pivot (max(val) for attrb_name in ('WORDS', 'CHARS', 'MATCH', 'SPACES'))
  order by rn

RN	FILE_	'WORDS'	'CHARS'	'MATCH'	'SPACES'
1	F1	0	2	4	6
2	F1	1	3	5	7
3	F2	7	8	9	0
4	F2	1	2	3	4
5	F3	0	2	0	4
6	F3	1	0	3	0
7	F4	3	6	9	0
8	F4	4	8	1	2