GV4_collection

SELECT GV4_13 as "TA", GV4_16 as "DT", GV4_19 as "Year", countryCode as "country_code"
FROM [UWWTD].[v1r2].[CP_source]
UNION
SELECT GV4_7 as "TA", GV4_10 as "DT", GV4_20 as "Year", countryCode as "country_code"
FROM [UWWTD].[v1r2].[CP_source]
UNION
SELECT GV4_1 as "TA", GV4_4 as "DT", GV4_21 as "Year", countryCode as "country_code"
FROM [UWWTD].[v1r2].[CP_source]
order by country_code, Year