I am using SPSS 19 on a Windows 7 PC.

I have a data set where there are multiple rows for each case and each row contains a separate variable and its data. I want to turn this into a data set where there is one row per case with multiple variables and data. I am a bit rusty on SPSS and am not sure how to accomplish this. Any advice welcome.

Currently:

case 1 Varname 1 Data 11

case 1 Varname 2 Data 12

case 1 Varname 3 Data 13

case 2 Varname 1 Data 21

case 2 Varname 2 Data 22

case 2 Varname 3 Data 23

Goal:

Case 1 Data 11 Data 12 Data 13

Case 2 Data 21 Data 22 Data 23

Thanks!