I was wondering if anyone might be able to help me restructure my data? I've been given an excel spreadsheet with data from two different years on it. So basically each participant has two different 'case' lines, one for each year. So:
V1 V2 V3 V4 V5 V6 etc
Obviously for appropriate analysis in SPSS I would like each participant to be represented by just one case and for the variables to be doubled up. As it's all in one file already I can't just use an SPSS merging technique based on the participant number. Is there any other simple way of doing it that I'm not aware of?
Thanks for your help,