Unstack Columns by Label or Subgroup

home · products · services · search · view cart · contact  
 
  NAVIGATION        
 

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



 

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. Stacked Data in Excel Data

  3. Next select Unstack Columns by Label (or Subgroup) from the Data Transformation sub menu.
  4. Unstack Data in Excel using the QI Macros

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

unstack data from one column to 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

QI Macros - One License Per Computer - Download with backup CD & User Guide (#230) $199 + S&H
QI Macros - One License Per Computer - Download Only - No Shipping or Customs Duties (#W230) $199
If you love the QI Macros...
Please ask a handful of friends to download the trial version. Here's what to say:
Need easy to learn, easy to use software for Lean Six Sigma and SPC that works right in Microsoft Excel? Test drive the QI Macros!
Find out more at www.qimacros.com/excel-spc-software.html.
Get a 30-day trial at www.qimacros.com/free-spc-software.html.

Going to a meeting of quality professionals?
We can send you as many QI Macros 30-day trial CDs as you need. Just send an email with the address and quantities needed to orders@qimacros.com.
 

Try QI Macros
FREE
For 30-Days


Or Buy It Now!

Unconditional
90-Day
Money-Back
Guarantee


 
home | products | services | search | sitemap | view cart | contact
QI Macros | Excel SPC Software | SPC Software Free Trial
Control Charts | c Chart | np Chart | p Chart | u Chart
ImR Chart | XmR Chart | XMedianR Chart | XbarR Chart | XbarS Chart | EWMA Chart
Anom Chart | Cusum Chart | Levey Jennings Chart | Moving Average Chart
Histograms | Pareto Chart | Scatter Plot | Run Chart
Box Whisker Plot | Dot Plot | Multivari Chart

Lean Six Sigma Training | Lean Six Sigma Training Denver
Lean Six Sigma Consulting | Lean Six Sigma Consulting Denver
Lean Six Sigma Training Systems | Do-It-Yourself Lean Six Sigma Training