What are stacked data and unstacked data?

Stacked and unstacked data are ways of arranging data in the worksheet.

C1 C2-T
Time to Complete Franchise
16 Altoona
18 Altoona
14 Harrisburg
13 Harrisburg
Stacked data

If data are stacked, the sample values for all groups are in a single column, with a corresponding column of labels that identifies the sample. This column of labels is referred to as a grouping column, By Column, or subscript column. In this example, the grouping column is Franchise.

C1 C2
Altoona Harrisburg
16 14
18 13
Unstacked data

If data are unstacked, each column contains observations from one group. There is no grouping column.

Stacking and unstacking data

Minitab offers tools in the Data menu so that you can stack unstacked data, or vice versa, although Minitab frequently will accept either format. You can stack or unstack data in the following ways:
Action Instructions
Stack data from separate columns into one column. Choose Data > Stack > Columns.
Stack data from two or more blocks of columns into one block of columns. Choose Data > Stack > Blocks of Columns.
Copy data entered across rows into one column. Choose Data > Stack > Rows.
Split the data in one or more columns into separate columns by values in a different column. Choose Data > Unstack Columns.
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy