Data > Stack > Columns

Complete the following steps to stack two or more columns on top of each other.

  1. In Stack the following columns, enter two or more columns to stack.
  2. From Store stacked data in, select one of the following storage locations:
    • New worksheet: Put the columns of stacked values in a new worksheet. You can enter a name for the worksheet.

    • Column of current worksheet: Put the column of stacked values in the active worksheet. Enter a column number (for example, C6) or a name.

      To store a column of subscripts, in Store subscripts in, enter a column number (for example, C8) or a column name. If the column name has more than one word, enclose the name in single quotation marks.

  3. If you entered a column in Store subscripts in, select Use variable names in subscript column to use the variable names for the subscript values. If you don't select this option, the subscript column contains 1s in rows that correspond to the first stacked column, 2s in rows that correspond to the second stacked column, and so on. You can use this subscript column for factor levels in analysis of variance procedures or as a by variable for other analyses. You can also use the subscripts to unstack a column.