st: transposing data

["Jeff NASTERNAK" <jnasternak2703@msn.com>]

hi,
I am using version 6 and am a new user.
I have data in the form:

ID   Pain
1     10
1     5
1     6
2     3
2     1
2      5


would like the data in the following form:

ID    Pain1     Pain2     Pain3
1     10         5           6
2     3           1           5


thank you for your help.
Jeff


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