Operation

• Split into Multiple Sheets - Using the specified rows form a new spreadsheet from these rows, and a second spreadsheet from the remaining rows. When a spreadsheet is split using Factor Groups, one spreadsheet for each factor level will be formed. If a selection of groups has been defined, then only the selected groups will have a spreadsheet formed for them.
• Subset to a single sheet - Using the specified rows form a new spreadsheet from these rows

Split Sheet Using

• Factor Groups The Factor drop down list specifies a factor to use to split the rows. If subsetting, the rows in the selected groups selected in the Factor Groups to Keep list will appear in the new sheet. If splitting, each selected group displayed in the Factor Groups to Keep list will be split into different spreadsheets. Note that if the spreadsheet contains no factors then this item will not be available. See Understanding Factors within a Spreadsheet for more help on factors.
• Restriction The current restriction is used to define the rows that are placed into the two spreadsheets, if splitting. The included rows are placed in the first spreadsheet and the excluded rows into the second. If subsetting, the Keep Restricted rows option in the Restriction list box will take the included rows for the subset, and the Keep Unrestricted rows choice will take the excluded rows. This item is only available if the spreadsheet has a restriction/filter currently defined. See Spreadsheet Restrict/Filter Menu for help on defining restrictions/filters.
• Selection The current row selection is used to define the rows that are placed into the two spreadsheets, if splitting. The selected rows are placed in the first spreadsheet and the unselected rows into the second. If subsetting, the Keep Selected rows option in the Selection list box will use the selected rows for the subset, and the Keep Unselected rows choice will use the unselected rows. This item is only available if the spreadsheet has a row selection currently defined. See how to select data or cells and Spreadsheet Select Menu for help on defining selections.
• Values in a Column The Values in drop down list specifies a column whose values are used to split the rows. The comparison used in the selection criterion is chosen from the drop down list of Equal to, Less than and Greater than. The value to compare with is specified the edit box following the comparison operator. For the Equal to comparison, multiple values may be given in a comma or space separated list (e.g. 1,2,5,8). If subsetting, rows that satisfy the criterion will appear in the new sheet, and if splitting, the unselected rows will be placed in a second spreadsheet.
• Random Sampling A random selection of rows will be selected for the new spreadsheet. If splitting, any row not selected in the random sample will appears in the second spreadsheet. The Number of Samples edit box specifies how many random samples will be used. The value can be interpreted as a percentage of the number of rows in the spreadsheet by selecting the % option. If the Sample with Replacement option is selected, then at each random selection of a row, all the available rows are eligible, otherwise only rows not yet selected are eligible for selection. If a column in the Weighting drop down list is selected, then the values in the selected column will be used in a weighted random sample. Rows with a weight value ≤ 0 or missing will not be included in the random sample. The Seed edit box defines an integer value that will be used to start the randomization. If a value of * is given for the seed, a value from the computer's clock will be used for the seed.

Create Unique column names

Use Factor Labels in column names

Action Buttons

See Also