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