Re: st: Spreadsheet to STATA

[David Backer <dabacker@umich.edu>]

Or you can first transpose the data in the spreadsheet, prior to pasting 
into the Stata data editor.  This is simple enough to do in any version of 
Microsoft Excel -- COPY, then PASTE SPECIAL selecting the TRANSPOSE 
option.

David Backer

On Tue, 6 Mar 2012, Richard Goldstein wrote:

> why not read it as is and then uses Stata's -xpose- command?
>
> Rich
>
> On 3/6/12 4:12 PM, solafem7@yahoo.co.uk wrote:
> > Hi
> >  Please, can anybody assist  me. Am trying to copy and paste data that are
> arranged in row form in spreadsheet to be in column form  in Data Editor in
> STATA. But I could not do this. Can anybody help with the trick?
> > Sola.
> *
> *   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/
*
*   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/