GV5

select countryCode as "country_code", ISNULL(GV5_1, 0) as "Value", 'Re-use in agriculture and other soil uses' as "Name", 1 as "vOrder"
FROM [UWWTD].[v1r2].[CP_source]
UNION
select countryCode as "country_code", ISNULL(GV5_2, 0) as "Value", 'Re-use other' as "Name", 2 as "vOrder"
FROM [UWWTD].[v1r2].[CP_source]
UNION
select countryCode as "country_code", ISNULL(GV5_3, 0) as "Value", 'Landfilling' as "Name", 3 as "vOrder"
FROM [UWWTD].[v1r2].[CP_source]
UNION
select countryCode as "country_code", ISNULL(GV5_4, 0) as "Value", 'Incineration' as "Name", 4 as "vOrder"
FROM [UWWTD].[v1r2].[CP_source]
UNION
select countryCode as "country_code", ISNULL(GV5_5, 0) as "Value", 'Dispose another way' as "Name", 5 as "vOrder"
FROM [UWWTD].[v1r2].[CP_source]
UNION
select countryCode as "country_code", ISNULL(GV5_6, 0) as "Value", 'Managed without further information reported' as "Name", 6 as "vOrder"
FROM [UWWTD].[v1r2].[CP_source]
order by country_code, vOrder