Unstack and Restack Data in Excel

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

We work with companies
that want to fire up their profits using
Lean Six Sigma

Copyright © 2011

The QI Macros Data Transformation Tools allow you to stack and unstack your data in Excel:

• Unstack Tables using Labels
• Unstack Labels by Subgroup
• Stack by Columns
• Restack Excel tables from JxK to MxN

Unstack tables using Labels

Unstack by Labels takes any size table and unstacks it based on the labels in column A.

Original data (Labels in Column A, Data in Column B)
unstacked into D1:E5 (by Region 1 and 2)

Unstack Labels by Subgroup

Another way to do this is to unstack by subgroup size. Using any number of columns, Unstack by Subgroups will use the number of samples per subgroup (in this case 4) and unstack the data.

Stack data by columns

Sometimes you need to stack columns of data. By specifying the number of columns to stack, the QI Macros will take the S1:S2 data above and transform it back into a single column (leaving the side-by-side data as well:

Restack Excel tables from JxK to MxN

Stack and Restack takes any size table and switches the data from one size table to a new size.

Original data (6X6)

Resulting data (3X12)

QI Macros Data Transformation Tools

• Box Cox Transformation
• Stack and Restack
• Get Sample From Table
• Paste Link and Paste Link Transpose
• PivotTable Wizard - Cross Tab
• Count Words in Selection
• Change Default Language
• Quick Keys On and Off
• Show / Hide Data Sheets

Other QI Macros and Control Chart Articles

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

Download
QI Macros
30-Day Trial Now!

Or Buy It Now!