Appendix3

SELECT IIF(countryName = 'EU-27', 'EU', countryCode) as "country_code", y2010 as "Value", '2010' as "Year"
FROM [UWWTD].[v1r2].[Appendix3]
UNION
SELECT IIF(countryName = 'EU-27', 'EU', countryCode) as "country_code", y2011 as "Value", '2011' as "Year"
FROM [UWWTD].[v1r2].[Appendix3]
UNION
SELECT IIF(countryName = 'EU-27', 'EU', countryCode) as "country_code", y2012 as "Value", '2012' as "Year"
FROM [UWWTD].[v1r2].[Appendix3]
UNION
SELECT IIF(countryName = 'EU-27', 'EU', countryCode) as "country_code", y2013 as "Value", '2013' as "Year"
FROM [UWWTD].[v1r2].[Appendix3]
UNION
SELECT IIF(countryName = 'EU-27', 'EU', countryCode) as "country_code", y2014 as "Value", '2014' as "Year"
FROM [UWWTD].[v1r2].[Appendix3]
UNION
SELECT IIF(countryName = 'EU-27', 'EU', countryCode) as "country_code", y2015 as "Value", '2015' as "Year"
FROM [UWWTD].[v1r2].[Appendix3]
UNION
SELECT IIF(countryName = 'EU-27', 'EU', countryCode) as "country_code", y2016 as "Value", '2016' as "Year"
FROM [UWWTD].[v1r2].[Appendix3]
UNION
SELECT IIF(countryName = 'EU-27', 'EU', countryCode) as "country_code", y2017 as "Value", '2017' as "Year"
FROM [UWWTD].[v1r2].[Appendix3]
UNION
SELECT IIF(countryName = 'EU-27', 'EU', countryCode) as "country_code", y2018 as "Value", '2018' as "Year"
FROM [UWWTD].[v1r2].[Appendix3]
UNION
SELECT IIF(countryName = 'EU-27', 'EU', countryCode) as "country_code", y2019 as "Value", '2019' as "Year"
FROM [UWWTD].[v1r2].[Appendix3]
UNION
SELECT IIF(countryName = 'EU-27', 'EU', countryCode) as "country_code", y2020 as "Value", '2020' as "Year"
FROM [UWWTD].[v1r2].[Appendix3]
UNION
SELECT IIF(countryName = 'EU-27', 'EU', countryCode) as "country_code", y2021 as "Value", '2021' as "Year"
FROM [UWWTD].[v1r2].[Appendix3]
UNION
SELECT IIF(countryName = 'EU-27', 'EU', countryCode) as "country_code", y2022 as "Value", '2022' as "Year"
FROM [UWWTD].[v1r2].[Appendix3]
order by country_code, Year