Introduction

The functions described in this sections are building blocks to do powerful pivoting and consolidating tables. All functions have been optimized to deliver maximum performance, even with very large tables. The functions described in the following sections cover follwing aspects:

• Transposing contents (i.e. contents in 1st column become row headers)
• Serializing horizontally laid out data
• Spreading serialized data out horizontally (opposite of above), and
• Consolidating tables (boiling tables down to fewer rows with specific consolidation actions serving as ingredients)

---

Procedures and Functions Provided:

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