You can use the PIVOT operator like shown below. If you have an unknown number of countries, or if the country names are not known in advance, you would have to use a dynamic query to construct the pivot.
ISNULL(Finland,0) + ISNULL(SWeden,0) + ISNULL(Norway,0) AS Total
SELECT Total_Active,MarketingName, Manufacturer, Country FROM TheTable
PIVOT (SUM(Total_active) FOR Country IN ([Finland],[Sweden],[Norway]))P