How Do I Transpose Data (Convert Cases Into Variables)?
Select Transpose from the Data menu, then select either Block or File. Transposing a block of data. The block transposing command affects only the contents of cells in the block currently selected in the spreadsheet (the block must be square); the variable names and case names will not be affected. For example, the Transpose – Block command executed on the following square block of data: produces the following result: Transposing a datafile. Datafile transposing restructures the entire file. For example, transposing the datafile shown above (before the block was transposed), changes the number of cases and variables in the datafile: Note that when you transpose a file, case names become variable names and variable names become case names.
