Hi everyone,
I have a data set of the following form:
Company name Company Identifier Sales by Region
X 111 125
X 111 135
X 111 145
Y 222 65
Y 222 75
Y 222 85
I would like to transform this into:
Company name Identifier Sales by region 1,2,3
X 111 125 135 145
Y 222 65 75 85
Is there any way I can do this? The transpose command
doesn't quite achieve this. Any help would be
appreciated.
Thank you.
Shyam Kumar
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
*
* 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/
