recipe.wrangle

delete row: IN($sourcerownumber, [1,3,2,4])
header
unpivot col: {1960}, {1961}, {1962}, {1963}, {1964}, {1965}, {1966}, {1967}, {1968}, {1969}, {1970}, {1971}, {1972}, {1973}, {1974}, {1975}, {1976}, {1977}, {1978}, {1979}, {1980}, {1981}, {1982}, {1983}, {1984}, {1985}, {1986}, {1987}, {1988}, {1989}, {1990}, {1991}, {1992}, {1993}, {1994}, {1995}, {1996}, {1997}, {1998}, {1999}, {2000}, {2001}, {2002}, {2003}, {2004}, {2005}, {2006}, {2007}, {2008}, {2009}, {2010}, {2011}, {2012}, {2013}, {2014}, {2015}, {2016}, {2017}, {2018}, {2019}, {2020} groupEvery: 1
rename type: manual mapping: [key,'Year']
drop col: column67 action: Drop
filter type: missing missing: value action: Delete
pivot col: {Indicator Name} group: {Country Name},{Country Code},Year value: AVERAGE(value) limit: 50