st: Stacking results

["Md. Alauddin Majumder" <mm4v@mtmail.mtsu.edu>]

Dear Statalist,
My Stata command (esttab) returns the following table:




Variables    Model-1    Model-2    Model-3
   x1              -0.03           -               -
   z1               0.01           -               - 
   
   x2                 -            0.05            -
   z2                 -            0.02            -
   
   x3                 -              -              0.07
   z3                 -              -             -0.02




where subscripts 1, 2, and 3 indicate models 1, 2, and 3 respectively, and models 1, 2, and 3 are for county 1, 2, and 3 respectively (that means x1, x2 and x3 are the values of x for county 1, 2, and 3 respectively).




I would like to stack the results as follows:
Variables    Model-1    Model-2    Model-3
   x               -0.03          0.05         0.07
   z                0.01          0.02        -0.02 
   
Is there any way to do this? Please note that I will have to use the subscripts (1,2, and 3) to retain the panel structure of data. Any help will be highly appreciated. Thanks.








Regards
Majumder
 

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/