st: How to transpose column into row?

[ZoeW <qingfw@yahoo.com>]

I have 2 variables (in column) with 10 observations (rows). They are all strings. Now I want to transpose them. Tried to use xpose, but all the strings were turned into missing. I want to keep the strings as is. 

Example:
Column1              C2              
Name               XXYY         
YEAR                  37
Gender               female

I want to change them into 
Name                    Year                      Gender …..
XXYY                   37                           female

Thanks,
Zoe



      

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/