Unstack Columns by Label or Subgroup

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar
2253 S. Oneida
Ste 3D
Denver, CO 80224

We help people think!

Copyright © 2008

Unstack Columns by Label will use whatever headers exist in column one of the selected data as the index or subscript to unstack the columns.

Unstack Columns by Subgroup will unstack columns using a number of samples per subgroup.

If the data is in rows, use Copy and Edit-Paste Special-Transpose to rotate the data into columns.

To use the Unstack Columns function in the QI Macros:

1. Select your data.



2. Next select Unstack Columns by Label (or Subgroup) from the Data Transformation sub menu.



3. Subgroup only: Input the new number of samples you want in each sugroup:
4. The macros will unstack the selected columns into multiple columns.

Other Data Transformation Tools

Data Transformation tools like Unstack Column by Label or Subgroup are just one of the tools included in the QI Macros for Excel SPC Software for Excel.

Download the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six Sigma