Date: Fri, 6 Nov 1998 13:10:10 -0500
Reply-To: Sandra Murray <smurray@DOE.STATE.VT.US>
Sender: "SPSSX(r) Discussion" <SPSSX-L@UGA.CC.UGA.EDU>
From: Sandra Murray <smurray@DOE.STATE.VT.US>
Subject: Pivoting Data...Is it posiible?
Content-Type: text/plain; charset=us-ascii
Hi - I am working with a huge database in that is structured
ineffectively for the work I wish to do with it. Is it possible for me
to "pivot" the data?
More specifically, this data captures responses for a survey
consisting of several questions, conducted with 70,000 people. The data
was all entered vertically - Variable 1 is a question and variable 2 are
the responses. On line 70,001 varaible 1 becomes the second question and
the for the next 70,000 lines, varaible 2 are the responses to that
question, and so on.
I want to arrange the questions across the spreadsheet horizontally
(as variables)and have just 70,000 rows in the spreadsheet - with each
case's responses appearing under the various questions that are spread
across the columns. Is this possible at the data editor level, or do we
have to re-enter the data?
If anyone has an answer or suggestion, I'd be most appreciative!!
Thank you - Sandy Murray