generate a line include several variables

[Yi Zi]

Hi, I am thinking how to generate ESG_Disclosure which include all years of ESG_disclosure score? so it will be: cusip year ESG_Disclosure_Score?
Thank you

* Example generated by -dataex-. To install: ssc install dataex
clear
input str25 cusip int year str21 esg_disclosure_2010 str8(esg_disclosure_2011 esg_disclosure_2012 esg_disclosure_2013 esg_disclosure_2014 esg_disclosure_2015 esg_disclosure_2016 esg_disclosure_2017) float(esg_disclosure_2019 esg_2020)
"#N/A Field Not Applicable" 2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Field Not Applicable" 2011 ""                      "" "" "" "" "" "" "" . .
"#N/A Field Not Applicable" 2012 ""                      "" "" "" "" "" "" "" . .
"#N/A Field Not Applicable" 2013 ""                      "" "" "" "" "" "" "" . .
"#N/A Field Not Applicable" 2014 ""                      "" "" "" "" "" "" "" . .
"#N/A Field Not Applicable" 2015 ""                      "" "" "" "" "" "" "" . .
"#N/A Field Not Applicable" 2016 ""                      "" "" "" "" "" "" "" . .
"#N/A Field Not Applicable" 2017 ""                      "" "" "" "" "" "" "" . .
"#N/A Field Not Applicable" 2019 ""                      "" "" "" "" "" "" "" . .
"#N/A Field Not Applicable" 2019 ""                      "" "" "" "" "" "" "" . .
"#N/A Field Not Applicable" 2020 ""                      "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
end

------------------ copy up to and including the previous line ------------------

[Chen Samulsion]

It is a reshape question. It seems that your data example has been distorted for anonymous or other reasons, but try the following code:

rename esg_2020 esg_disclosure_2020
tostring esg_disclosure_2019 esg_disclosure_2020, replace
gen id=_n
reshape long esg_disclosure_, i(id) j(year2)
rename esg_disclosure_ esg_disclosure_score

[Yi Zi]

Thank you Chen!