# Transform

Table transformation may be as simple as using the [Select Columns](https://docs.auditboardanalytics.com/tools/transform/select-columns) tool to retain or omit a column. However, many transform tools, offer spreadsheet-style formula entry. [Edit Columns](https://docs.auditboardanalytics.com/tools/transform/edit-columns) lets you write a formula -- and get a new calculation. The [Filter](https://docs.auditboardanalytics.com/tools/transform/filter) tool splits rows into True/False outputs, based on your criteria. [Pivot](https://docs.auditboardanalytics.com/tools/transform/pivot) will allow you to aggregate and summarize a table by its columns.

<table data-card-size="large" data-view="cards"><thead><tr><th></th><th></th></tr></thead><tbody><tr><td><a href="transform/add-columns">Add Columns</a></td><td>Add new expression-based columns, by writing a quick formula</td></tr><tr><td><a href="transform/edit-columns">Edit Columns</a></td><td>Rename, retype, and reformat columns, provide metadata</td></tr><tr><td><a href="transform/select-columns">Select Columns</a></td><td>Select Columns allows you to keep or drop selected columns from a table.</td></tr><tr><td><a href="transform/filter">Filter</a></td><td>Select records from a table based on row criteria</td></tr><tr><td><a href="transform/sort">Sort</a></td><td>Reorder a table based on row values</td></tr><tr><td><a href="transform/pivot">Pivot</a></td><td>Aggregate the values in a table</td></tr><tr><td><a href="transform/unpivot">Unpivot</a></td><td>Convert column values into rows</td></tr><tr><td><a href="transform/deduplicate">Deduplicate</a></td><td>Remove duplicate values in a column</td></tr><tr><td><a href="code/pythoncode">Python</a></td><td>Allows for custom Python code to be executed against tables and objects inside an Analytics Workflow. One can ingest any number of sources and output any number of objects.</td></tr></tbody></table>