So here's an example of what I have, and an explanation of what I am looking for. I can't seem to get the restructure function in SPSS to work properly, could be the wrong tool for the job. Any help would be appreciated. Thank you!
- ID | Car_Make | Car_Model
- 999, Subaru, WRX
- 867, Volvo, 240
- 999,Acura, TSX
- ID | Car_Make1 | Car_Model1 | Car_Make2 | Car_Model2.....(Dependent on list)
- 999, Subaru, WRX, Acura, TSX
- 867, Volvo, 240
Any thoughts? Thank you!
What you are missing is a key\index variable. Try this: