When viewing any table, you can move rows and columns by dragging and dropping (i.e., click on the row or column of interest and drag it to where you would like it to be). Merging is done in the same way, except that you drag one category on top of another and release your mouse button (i.e., ‘drop’ one category onto another).
You can rename a row or category by right-clicking on it and selecting Rename. Alternatively, if the category has not been merged with other categories, right-click on it and select Values and edit the label in the Value Attributes dialog box.
Moving, merging, and copying categories
- To move a row or category click on it and drag it to where you want it to go.
- If when moving a row or category you release it on top of another category it will merge.
- Hold down the Shift or Ctrl button on your keyboard, select categories that you wish to combine, and right-click and select Merge to combine them.
- If you wish to copy a row or category, right-click and select Copy.
Creating NET categories
Hold down the Shift or Ctrl button on your keyboard, select categories that you wish to use to create a NET, right-click and select Create NET.
Right-click on the column or row that you wish to use to use as the basis for the sort, select Sort By and whichever of the options are appropriate. If you wish to have the sort order update when the data changes, please see How to Automatically Sort Table Rows.
Automatic reordering of rows and columns
Right-click on a row or column category and select Reorder rows or Reorder columns and Q will reorder the rows and columns in a way that may make patterns on the table easier to view (the algorithm attempts to Diagonalize the table).
Undoing changes that have been made to the rows and columns on a table
If you inadvertently merge categories, you can unmerge them by pressing , clicking your right mouse button on the category, and selecting Split, or, if you wish the table to appear as it did prior to editing, you can select Revert.
How to Automatically Sort Table Rows
How to Change the Order of Statistics in a Table
Article is closed for comments.