st: Re: transposing rows

["Sergiy Radyakin" <Radyakin@aoek.uni-hannover.de>]

Hi,

If your data are stored in Excel, you can transpose it in Excel -- copy, 
paste special, choose transpose as an option, done.
Note that you are limited to 256 variables though (A,B,...,IV)

Best regards,
  Sergiy

----- Original Message ----- 
From: <agostino@unical.it>
To: <statalist@hsphsun2.harvard.edu>
Sent: Wednesday, March 07, 2007 11:11 AM
Subject: st: transposing rows



> 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/ 
*
*   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/