create table TestData(Description varchar(255), Region_Code varchar(10), WholeACNet float)

insert into TestData values ('Original', 'AU', 1973026688)
insert into TestData values ('RiverLakes_WWFL', 'AU', 112926275)
insert into TestData values ('RiverLakesSev123_WWFL', 'AU', 1718559478)
insert into TestData values ('Original', 'BR', 1000539676)
insert into TestData values ('RiverLakes_WWFL', 'BR', 445413235)
insert into TestData values ('RiverLakesSev123_WWFL', 'BR', 1059705496)
insert into TestData values ('Original', 'CA', 2269091781)
insert into TestData values ('RiverLakes_WWFL', 'CA', 890979921)
insert into TestData values ('RiverLakesSev123_WWFL', 'CA', 997114545)

 SELECT Region_Code, Original = COUNT(CASE WHEN description = 'Original' THEN 1 ELSE 0 END),
RiverLakes_WWFL = COUNT(CASE WHEN description = 'RiverLakes_WWFL' then 1 ELSE 0 END),
RiverLakesSev123_WWFL = count(CASE WHEN description = 'RiverLakesSev123_WWFL' THEN 1 ELSE 0 END)
FROM [TestAndLearn].[dbo].[TestData]
group by region_code

SELECT Region_Code,
	[Original],
	[RiverLakes_WWFL],
	[RiverLakesSev123_WWFL]
FROM TestData
	PIVOT (
		SUM(WholeACNet) 
		FOR Description in (
			[Original],
			[RiverLakes_WWFL],
			[RiverLakesSev123_WWFL]
		)
	) p

SELECT Region_Code, Original = Max(CASE WHEN description = 'Original' THEN WholeACNet  END),
RiverLakes_WWFL = max(CASE WHEN description = 'RiverLakes_WWFL' then WholeACNet  END),
RiverLakesSev123_WWFL = Max(CASE WHEN description = 'RiverLakesSev123_WWFL' THEN WholeACNet END)
FROM [TestAndLearn].[dbo].[TestData]
group by region_code