Example of Stack Columns

A quality engineer records pipe diameters in separate columns for each week. The engineer wants to combine all measurements into a single column of diameters.

  1. Open the sample data, PipeDiameter.MTW.
  2. Choose Data > Stack > Columns.
  3. In Stack the following columns, enter Week 1 Week 2 Week 3.
  4. From Store stacked data in, select Column of current worksheet, then type Diameter.
  5. In Store subscripts in, type ID.
  6. Select Use variable names in subscript column.
  7. Click OK.

Results

Week 1, Week 2, and Week 3 contain the unstacked data. The stacked data are in Diameter. The corresponding subscripts are in ID.

C1 C2 C3 ... C6 C7-T
Week 1 Week 2 Week 3 ... Diameter ID
5.19 5.57 8.73 ... 5.19 Week 1
5.53 5.11 5.01 ... 5.53 Week 1
4.78 5.76 7.59 ... 4.78 Week 1
5.44 5.65 4.73 ... 5.44 Week 1
4.47 4.99 4.93 ... 4.47 Week 1
4.78 5.25 5.19 ... 4.78 Week 1
4.25 7.00 6.77 ... 4.25 Week 1
5.70 5.20 5.66 ... 5.70 Week 1
4.40 5.30 6.48 ... 4.40 Week 1
5.64 4.91 5.20 ... 5.64 Week 1
      ... 5.57 Week 2
      ... 5.11 Week 2
      ... 5.76 Week 2
      ... 5.65 Week 2
      ... ... ...
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy