Items in this menu can be used to manipulate the data in a whole spreadsheet.
Append Data to Spreadsheet
Append data to the bottom of the spreadsheet from other data sources.
Change the spreadsheet from one type (Vector, Matrix, Table etc.) to another type.
Duplicate a Spreadsheet
Create another spreadsheet from the current spreadsheet.
Merge data from another open spreadsheet into this spreadsheet, specifying how rows and columns are to be matched.
Create a new spreadsheet from this spreadsheet by stacking multiple columns into a single columns.
Create a new spreadsheet from this spreadsheet by unstacking a single column into multiple columns, based on the grouping specified in a factor.
Reshapes a spreadsheet with classifying factors for rows and columns,
into a reorganized spreadsheet with new identifying factors.
Create a new spreadsheet from this spreadsheet by swapping the rows to become columns (or vice-versa).
Split or Subset a Spreadsheet
Split or subset the current spreadsheet to create new spreadsheet(s).
Sort the spreadsheet rows into random order, optionally within factor groups which may be also randomized in the order that the labels appear.
Expand a Spreadsheet using a Weight Column
Create a new spreadsheet by expanding the current spreadsheet using a weights column.
Reorder Spreadsheet Table margins
Swap the order of the classifying factors of the multi-way table.