Unstack and Restack Data in Excel
QI Macros Makes it Easy to Stack & Unstack Data in Excel
You can find the restacking and unstacking tools in the Restacking section of the QI Macros menu:
To use the restacking and unstacking tools:
- Click and drag over your data to select it.
- Click on QI Macros menu and select the restack/unstack function you want.
- Answer the prompts and QI Macros will reorganize your data for you.
If you have multiple columns of data and would like to stack your data into a single column, use this tool. It will automatically place a blank row between your different data sets!
NOTE: Included in the January 2021 release, this functionality is utilized if an end user has multiple columns in their data set and chooses to create a single-column Variable Control Chart (e.g. XmR Chart).
Sometimes you need to stack several columns of data into fewer columns or even into one column. QI Macros will prompt you for how many columns of data you want to end up with. In this example, we chose "1". QI Macros leaves the original data and makes a copy into the new format:
Stack or Restack takes any size table and switches the data into as many columns as you choose. You can increase or decrease the number of columns:
Data Before 6x6 Table
Data After 3x12 Table
Unstack by Label takes any size table and unstacks it based on the labels in column A:
This functionality is designed to take a column of data that has multiple labels (e.g., entity and shift) and group it into columns for each label combination (e.g., entity - shift):
Using any number of columns, Unstack by Subgroup will use the number of samples per subgroup (in this case 4) and unstack the data. This function is generally used to go from one column to many:
This functionality is designed to take a group of multi-column data that has multiple labels and groups them into a single-column list of data:
NOTE: Included in the April 2020 release, the Unstack Matrix is now able to process zeroes within your data set.
This functionality is designed to take either a single or multi-column set of data and put it into random order, depending on the number of samples you would like to randomize.
To do so, simply highlight your data:
Input the "Number of Samples" you would like to randomize:
Do you have any headers in your data set?
(NOTE: You do NOT need to include headers in your data set):
You will then be provided with a randomized set of data based upon the number of samples you chose to generate.
NOTE: This functionality is included in the October 2022 release.
Why Choose QI Macros Add-in for Excel
- Only $329 USD - less with quantity discounts
- No annual subscription fees
- Free technical support
Easy to Use
- Works right in Excel
- Create a chart in seconds
- Easy to customize & share charts
Proven and Trusted
- More than 100,000 users
- In More than 80 countries
- Five Star CNET Rating - Virus free