Introduction
The functions described next provide efficient means to process tables effectively, including:
- Checking and processing headers
- Processing table columns
- Processing table rows, and
- Processing table contents
- Pivoting and consolidating tables
- Copying, renaming and splitting tables
Procedures and Functions Provided:
Checking and processing headers:
table check header
table column number
table check headers
table check headers silently
table rename column headers
table rename existing headers
table rename headers
table correct headers
table correct headers ignore case
table lift contents
table lift header row
table lift headers
Inserting table columns:
table insert columns
table insert missing columns
Inserting calculated table columns:
table add calculated columns
table insert calculated columns
Copying table columns:
table copy columns
table copy columns selected rows
table duplicate columns
Sorting and rearranging table columns:
table sort columns
table rearrange columns
table rearrange existing columns
Keeping and deleting table columns:
table keep columns
table keep existing columns
table delete columns
table delete remaining columns
table delete all blank columns
table delete all empty columns
table delete all unnamed columns
table delete blank columns
table delete empty columns
table delete unnamed columns
Insert table rows:
table insert rows
table insert rows if needed
table insert above selected rows
table insert selected rows
Deleting table rows:
table delete rows
table delete rows if needed
table delete remaining rows
table delete remaining rows if needed
table delete selected rows
table keep selected rows
table delete blank rows
Check table rows:
table check row
Move and rearrange table rows:
table move rows
table move selected rows
table rearrange selected rows
Sort and rearrange table rows:
table sort rows
table sort selected rows
table rank rows
table rank selected rows
Process table rows:
table process
table process all rows
table process all selected rows
table process rows
table process selected rows
table process selected rows fast
Process table columns:
table process columns
table process selected columns
Process table cells:
table process all cells
table process cells
table process cells selected rows
table process cells in columns
table process cells selected rows in columns
Manipulate table contents:
table manipulate
table manipulate selected rows
Table filling and substitution functions:
table fill vertically
table fill vertically selected rows
table fill horizontally
table fill horizontally selected rows
table substitute vertically
table substitute vertically selected rows
table substitute horizontally
table substitute horizontally selected rows
Insert table contents:
table insert cells selected rows
table insert cells in columns
Delete table contents:
table delete cells selected rows
table delete cells in columns
Rotate tables:
table flip horizontally
table flip vertically
Rotate tables:
table rotate left
table rotate right
Cleaning up and miscellaneous table functions:
table format numbers
table clean
table fit
Flip columns:
table flip columns
Flip rows:
table flip rows
table flip selected rows
Transpose tables:
table transpose
Change tabular contents to serialized contents:
table serialize
table serialize all
table serialize ignore zero
Spread serialized data across specified columns:
table spread
table spread accumulating
table spread given headers
table spread given headers accumulating
Consolidate table rows:
table consolidate
table consolidate selected rows
Distribute quantities over timeline:
table distribute
table distribute accumulate
table distribute advance
table distribute advance accumulate
Create histograms from tables:
table histogram
Renaming tables:
table rename
Copy and split tables:
table copy table
table copy table selected rows
table split table selected rows
table copy table columns
table copy table columns selected rows
table split table columns