The most direct way to gain familiarity with the data restructuring techniques in SPSS is to work through an example. In the sample data shown in the following screenshot, cholesterol test results for five patients are provided with separate rows for total cholesterol, HDL, and LDL:
Test results such as these are used to calculate the ratio of HDL to total cholesterol and to calculate the non-HDL cholesterol. Deriving these values requires that all the patient results are on the same record and the data must be restructured before the calculations can be made.
Once this spreadsheet has been opened in SPSS, use the ...