Good Evening, I am trying to build a panel dataset from a list of Banks that I have downloaded from the Bankscope website.
I have NPL Ratio observation from 2018 to 2000
I have imported my data from excel and I have something like


Code:
 * Example generated by -dataex-. To install: ssc install dataex
clear
input str119 bank str2 country str17(nplratio18 nplratio17 nplratio16 nplratio15)

"BANCO SANTANDER SA"                                                     "ES" "3.89"              "4.3"   "4.13"  "4.53"
"BNP PARIBAS SA"                                                         "FR" "4.3"               "4.93"  "5.65"  "5.82"
(Consider that I have over 8000 Bank, I have just reported 2 for simplicity)

And I Would Like to have a panel dataset that then I will merge with other variables.
I know that I should use the reshape command but I am not able to figure how it works.
Any help will be really appriciated.