The following options should work with most versions of SPSS:
a) Read the .XLS into SPSS and then use VARSTOCASES to transpose it.
or
b) Transpose in XLS first (Use Edit/Copy to select the portion you want
to convert then Edit/Paste/Transpose to paste it into a new spreadsheet)
Option A handles it all in syntax if this is a reoccuring task.
Option B is simpler if this is a one time issue.
Dennis Deck, PhD
RMC Research Corporation
111 SW Columbia Street, Suite 1200
Portland, Oregon 97201-5843
voice: 503-223-8248 x715
voice: 800-788-1887 x715
fax: 503-223-8248
[hidden email]
-----Original Message-----
From: Vincent Mallet [mailto:
[hidden email]]
Sent: Saturday, February 09, 2008 2:17 PM
Subject: Pasting from xls in SPSS 16.0.1 MAC
Is there a way to paste columns from xls to SPSS? It seems to work only
with rows?
Vincent
=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
Locked
