Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: transposing rows


From   agostino@unical.it
To   statalist@hsphsun2.harvard.edu
Subject   st: transposing rows
Date   Wed, 7 Mar 2007 11:11:49 +0100

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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index