Hi,

How could get the first row first Column: Germany to become a panel (so to match each observation. And then to name each column by their second row? So column names should be, year, Pproducer price index for industrial products and annual change.



Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str78 A str44 B str13 C
"Germany"                                                                        ""                                             ""             
"Year"                                                                           "Producer price index for industrial products" "Annual change"
""                                                                               "2015=100"                                     "in (%)"       
"2007"                                                                           "93.8"                                         "1.3"          
"2008"                                                                           "99"                                           "5.5"          
"2009"                                                                           "94.8"                                         "-4.2"         
"2010"                                                                           "96.2"                                         "1.5"          
"2011"                                                                           "101.3"                                        "5.3"          
"2012"                                                                           "103"                                          "1.7"          
"2013"                                                                           "102.9"                                        "-.1"          
"2014"                                                                           "101.9"                                        "-1"           
"2015"                                                                           "100"                                          "-1.9"         
"2016"                                                                           "98.40000000000001"                            "-1.6"         
"2017"                                                                           "101.1"                                        "2.7"          
"______________"                                                                 ""                                             ""             
""                                                                               ""                                             ""             
end