Example of Stack Blocks of Columns

A quality engineer records pipe diameters in separate columns for each week, along with the machine that produced them. The engineer wants to combine all diameters into a single column with a corresponding machine column.

  1. Open the sample data, PipeDiameter.MTW.
  2. Choose Data > Stack > Blocks of Columns.
  3. In Stack two or more blocks of columns on top of each other, enter Week 1 Machine in the first box, Week 2 Machine in the second box, and Week 3 Machine in the third box.
  4. From Store stacked data in, select Columns of current worksheet, then type Diameter 'Machine Number'.
  5. In Store subscripts in, type ID.
  6. Select Use variable names in subscript column.
  7. Click OK.

Results

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

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