Pivot tables arise in various situations: * EAV model * Spreadsheets * List of columns not known during schema design * Data Analysis (pivot operation of an OLAP Cube) * Incoming data from a key-value datastore