Transposes (interchanges the columns and rows of) the given table.
TableTranspose([Table])
Where:
Table is the table that is to be filtered.
Rule | Meaning |
|---|---|
| TableTranspose(DwLookupItems) | Inverts the example Items table (shown below) so the data in column 1 becomes the data in row 1, and the data in row 1 become data in column 1, resulting in: {"Item","Single Drawer Unit","Double Drawer Unit","Single Cupboard Full","Double Cupboard Full","Single Cupboard with Drawer","Double Cupboard with Drawer","Cupboard Left Drawer Right","Cupboard Right Drawer Left","Single Cupboard with Drawer","Double Cupboard with Drawer","Cupboard Left Drawer Right","Cupboard Right Drawer Left";"Width","600","900","600","900","600","1200","1200","1200","600","1200","1200","1200";"Position","Rear Wall","Rear Wall","Rear Wall","Rear Wall","Left Wall","Left Wall","Left Wall","Left Wall","Right Wall","Right Wall","Right Wall","Right Wall";"Cost","330","495","280","440","300","600","610","610","300","600","610","610"} |
Items Table
| Item | Width | Position | Cost |
|---|---|---|---|
| Single Drawer Unit | 600 | Rear Wall | 330 |
| Double Drawer Unit | 900 | Rear Wall | 495 |
| Single Cupboard Full | 600 | Rear Wall | 280 |
| Double Cupboard Full | 900 | Rear Wall | 440 |
| Single Cupboard with Drawer | 600 | Left Wall | 300 |
| Double Cupboard with Drawer | 1200 | Left Wall | 600 |
| Cupboard Left Drawer Right | 1200 | Left Wall | 610 |
| Cupboard Right Drawer Left | 1200 | Left Wall | 610 |
| Single Cupboard with Drawer | 600 | Right Wall | 300 |
| Double Cupboard with Drawer | 1200 | Right Wall | 600 |
| Cupboard Left Drawer Right | 1200 | Right Wall | 610 |
| Cupboard Right Drawer Left | 1200 | Right Wall | 610 |
See also