SQL UNPIVOT

SELECT Year, Month, Half, Fiscal_Year, Quater, department, value
FROM 
(
  SELECT Year, Month, Half, Fiscal_Year, Quater, 制作１, 制作２, ..., 制作N
  FROM your_table
) AS source_table
UNPIVOT
(
  value FOR department IN (制作１, 制作２, ..., 制作N)
) AS unpivot_table;

SELECT Year, Month, Half, Fiscal_Year, Quater, '制作１' AS Department, 制作１ AS Value FROM your_table
UNION ALL
SELECT Year, Month, Half, Fiscal_Year, Quater, '制作２' AS Department, 制作２ AS Value FROM your_table
UNION ALL
...
SELECT Year, Month, Half, Fiscal_Year, Quater, '制作N' AS Department, 制作N AS Value FROM your_table