SPSS formatting issues

I have collected SF-36 (multi choice QoL data) for a few hundred patients over three time periods.

When the data has been entered after each time period a new row was created in SPSS.

Meaning i have three rows containing the different Qol at the different time periods for each patient.

However I realise i need the values for each participant appear on one row, and only on one row.

Is there anyway i can do this with formatting or sorting data?

Your help is appreciated


I think you're looking to go from long to wide format. I'm not an SPSS user but here's a link to one of my favorite sites UCLA and their tutorial on how to do this in SPSS (LINK).