Transforming "Vertical" Regression Output Into a "Horizontal" Table Format

A recent Statalist discussion (here) walks readers through the coding necessary to transform the following (traditionally "vertical") regression output:

-----------------------------------------
                               mpg       
-----------------------------------------
Weight (lbs.)                      -0.006
                       [-0.009    -0.003]
                                     0.00
Displacement (cu. in.)              0.006
                       [-0.014     0.025]
                                     0.57
Turn circle (ft.)                  -0.139
                       [-0.496     0.219]
                                     0.44
Intercept                          43.588
                       [33.688    53.489]
                                     0.00
Number of observations                 74
-----------------------------------------

into a "horizontal" output format:

-------------------------------------------------------------
                       Coefficient       95% CI       p-value
-------------------------------------------------------------
Weight (lbs.)               -0.006 [-0.009    -0.003]    0.00
Displacement (cu. in.)       0.006 [-0.014     0.025]    0.57
Turn circle (ft.)           -0.139 [-0.496     0.219]    0.44
Intercept                   43.588 [33.688    53.489]    0.00
-------------------------------------------------------------