Dear all,
my data are stored in an excel file where each row contains a variable and
each column represents a year, as follows:
1994 1995 1996 1997
TOTAL SALES 844854 949870 956692 876844
DEPRECIATION NA 38477 39937 36588
DEPN NA NA NA NA
OPERATING PROFIT 52971 93029 93613 112022
I need to transpose the rows so that each variable is contained in a column
and each row represents a year. In other words I need to get:
TOTAL SALES DEPRECIATION DEPN OPERATING PROFITS
1994
1995
1996
1997
Does anyone know how STATA can do it?
Thanks for your help
Mariarosaria
-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
