GV10_AT

SELECT GV10_1 as "Excellent", GV10_4 as "Good", '1' as "Poor", GV10_10 as "NoClass", '2010' as "Year", countryCode as "country_code"
FROM [UWWTD].[v1r2].[CP_source]
Union
SELECT GV10_2 as "Excellent", GV10_5 as "Good", GV10_8 as "Poor", GV10_11 as "NoClass", '2016' as "Year", countryCode as "country_code"
FROM [UWWTD].[v1r2].[CP_source]
UNION
SELECT GV10_3 as "Excellent", GV10_6 as "Good", GV10_9 as "Poor", GV10_12 as "NoClass", '2022 (latest)' as "Year", countryCode as "country_code"
FROM [UWWTD].[v1r2].[CP_source]