GV3

SELECT GV3_1 as "Target achieved", '0' as "Distance to target", 'Total generated' as "Name", countryCode as "country_code"
FROM [UWWTD].[v1r2].[CP_source]
UNION
SELECT GV3_2 as "Target achieved", GV3_5 as "Distance to target", 'Collection' as "Name", countryCode as "country_code"
FROM [UWWTD].[v1r2].[CP_source]
UNION
SELECT GV3_3 as "Target achieved", GV3_6 as "Distance to target", 'Biological treatment' as "Name", countryCode as "country_code"
FROM [UWWTD].[v1r2].[CP_source]
UNION
SELECT GV3_4 as "Target achieved", GV3_7 as "Distance to target", 'Biological treatment with \n' + Vmain2 as "Name", countryCode as "country_code"
FROM [UWWTD].[v1r2].[CP_source]