GV4_biological

SELECT GV4_14 as "TA", GV4_17 as "DT", GV4_19 as "Year", countryCode as "country_code"
FROM [WISE_UWWTD].[latest].[CP_source]
UNION
SELECT GV4_8 as "TA", GV4_11 as "DT", GV4_20 as "Year", countryCode as "country_code"
FROM [WISE_UWWTD].[latest].[CP_source]
UNION
SELECT GV4_2 as "TA", GV4_5 as "DT", GV4_21 as "Year", countryCode as "country_code"
FROM [WISE_UWWTD].[latest].[CP_source]
order by country_code, Year