Stack columns in the worksheet

In the Stack Columns dialog box, enter the columns to stack and specify whether to use column names or integers as IDs for the stacked data.

  1. In Stack the following columns, enter the columns to stack.
  2. Under Values in ID column, indicate how you want to identify the original source column for each row of stacked data:
    • Input column names: Create a text column that contains the name (or column ID) of the original source column.
    • Integers: Create a numeric column with the values 1, 2, 3, and so on. The numbers correspond to the order of the columns in the Stack the following columns box.
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy