Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

I want to stack my data, but the spreadsheet that is created from the stacking operation doesn have the values in the order I expected. What options should be adjusted?

0
10 Posted

I want to stack my data, but the spreadsheet that is created from the stacking operation doesn have the values in the order I expected. What options should be adjusted?

0
10

In stacking, there are two options that pertain to how the data will be ordered in the spreadsheet: either interleaved or not. On the Stacking tab of the Unstacking/Stacking dialog (accessible by selecting Unstacking/Stacking from the Data menu), select the Interleave output check box to stack the cases as they are ordered in the original spreadsheet (i.e., with the values from Case 1 stacked upon the values from Case 2, which are stacked upon the values of Case 3, etc.). Clear this option to stack the output by the groups in the Code variable (i.e., with the values from the first stacking variable stacked upon the values of the second stacking variable, which are stacked upon the values of the third stacking variable, etc.).

Related Questions

What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.

Experts123