st: How to transpose columns into rows?

[ZoeW <qingfw@yahoo.com>]

How to transpose column into row? 

I have 2 variables (in column) with 10 observations (rows). They are all strings. Now I want to transpose them. Tried 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/