GV1

select countryCode as "country_code", ISNULL(GV1_1, 0) as "Value", 'Biological with treatment with ' + Vmain2 as "Name", '1' as "QOrder"
FROM [UWWTD].[v1r2].[CP_source]
UNION
select countryCode as "country_code", ISNULL(GV1_2, 0) as "Value", 'Biological treatment' as "Name", '2' as "QOrder"
FROM [UWWTD].[v1r2].[CP_source]
UNION
select countryCode as "country_code", ISNULL(GV1_3, 0) as "Value", 'Primary treatment' as "Name", '3' as "QOrder"
FROM [UWWTD].[v1r2].[CP_source]
order by country_code, QOrder