Example of stack columns

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

  1. Open the sample data, PipeDiameter.MTW.
  2. Open the Stack Columns dialog box.
    • Mac: Data > Stack Columns
    • PC: DATA > Stack Columns
  3. In Stack the following columns, enter Week 1 Week 2 Week 3.
  4. Click OK.

Results

Columns C1–C3 contain the unstacked data. The stacked data are in column C7. The corresponding IDs are in column C6.

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