Desired result ..
SELECT 'Invest' AS TYPE,'XXX' AS Unit,0 AS ForeCast,1 AS Week,9190.2 AS Trend
UNION
SELECT 'Invest' AS Type,'XXX' AS Unit,0 AS ForeCast,2 AS Week,18380.4 AS Trend
UNION
SELECT 'Invest' AS TYPE,'XXX' AS Unit,0 AS ForeCast,3 AS Week,27570.6 AS Trend
UNION
SELECT 'Invest' AS Type,'XXX' AS Unit,0 AS ForeCast,4 AS Week,36760.8 AS Trend
UNION
SELECT 'Invest' AS Type,'XXX' AS Unit, 45951 AS ForeCast,5 AS Week,45951 AS Trend