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?
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
- 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?
- User copies several values (at once) from a local excel spreadsheet and pastes them into the jdatagrid, is this feature supported?
- Besides the local MLS, are there data sources for luxury homes (Values > $750k)?