SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE yourtable
    ([Scheme Code] varchar(5), [MonthYear] varchar(6), [Revenue] int, [Revenue2] int)
;
    
INSERT INTO yourtable
    ([Scheme Code], [MonthYear], [Revenue], [Revenue2])
VALUES
    ('18VDA', '2018.1', 100, 50),
    ('18VDA', '2018.2', 200, 100),
    ('18VDA', '2018.3', 200, 150)
3 rows affected

select *
from
(
	select 
		t.[Scheme Code],
		new_colname = concat(t.[MonthYear], ' ', r.colname),
		r.colvalue
	from yourtable t
	cross apply
	(
		select 'A', Revenue union all
		select 'B', Revenue2
	) r (colname, colvalue)
) d
pivot 
(
	sum(colvalue)
	for new_colname in ([2018.1 A], [2018.2 A], [2018.3 A], [2018.1 B], [2018.2 B], [2018.3 B])
) p;


Scheme Code
2018.1 A
2018.2 A
2018.3 A
2018.1 B
2018.2 B
2018.3 B


18VDA
100
200
200
50
100
150


DECLARE @cols AS NVARCHAR(MAX);
Declare @query  AS NVARCHAR(MAX);

Select @cols = STUFF((SELECT ',' + QUOTENAME(concat([MonthYear], x.col)) 
                    from yourtable
					cross join (select col = ' A' union all select ' B') x
                    group by [MonthYear], x.col
            FOR XML PATH(''), TYPE
            ).value('.', 'NVARCHAR(MAX)') 
        ,1,1,'');

set @query = 'SELECT *
             FROM 
			 ( 
				select 
					t.[Scheme Code],
					new_colname = concat(t.[MonthYear], '' '', r.colname),
					r.colvalue
				from yourtable t
				cross apply
				(
					select ''A'', Revenue union all
					select ''B'', Revenue2
				) r (colname, colvalue)
              ) a
              PIVOT
			  (
				sum(colvalue) for new_colname in (' + @cols + ') 
              ) as x
              ORDER BY [Scheme Code]';

exec sp_executesql @query;


Scheme Code
2018.1 A
2018.1 B
2018.2 A
2018.2 B
2018.3 A
2018.3 B


18VDA
100
50
200
100
200
150