Transpose columns

Data > Transpose Columns

Complete the following steps to transpose columns.

  1. In Transpose the following columns, enter one or more columns to transpose. The columns must have the same number of rows.
  2. From Store transpose, select one of the following storage options:
    • In new worksheet: Put the transposed columns in a new worksheet. You can enter a name for the worksheet.
    • After last column in use: Put the transposed columns at the end of the active worksheet.
  3. (Optional) In Create variable names using column, enter the column that contains the values to use for the variable names for the transposed data.