How do I transpose data (convert cases into variables)?

Ribbon Bar. Select the Data tab. In the Transformations group, click Transpose and from the drop-down menu, select either Transpose Block or Transpose File (descriptions of both are below).

Classic Menus. Select either Block or File from the Data - Transpose submenu.

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 data file. Data file transposing restructures the entire file. For example, transposing the data file shown above (before the block was transposed), changes the number of cases and variables in the data file: