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

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 in columns selected rows

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

Delete table contents:
    table delete cells selected rows
    table delete cells selected columns

Cleaning up and miscellaneous table functions:
    table format numbers
    table clean
    table fit

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, e.g. for production planning:
    table distribute
    table distribute accumulate
    table distribute advance
    table distribute advance accumulate

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