Code:
select 'A' "Level 2", A "Rate" from my_table
  UNION ALL
select 'B' "Level 2", B "Rate" from my_table
  UNION ALL
etc