Hi there,
I am tasked with analyzing data from Excel using SPSS; I know how to export the data from Excel to SPSS, but the data in Excel is on two lines....meaning participant pretest scores are on one row in Excel, and then their posttest scores are on the line right below it - both are identified with the same subject ID number. I need to get all of this data on one row (for each case) but there are over 11,000 participants! Is there an easy way to do this, or am I going to be forced to do it all by hand (i.e., cut and paste)?