> For the complete documentation index, see [llms.txt](https://docs.cascade.io/cascade/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.cascade.io/cascade/tools/transform.md).

# Transform

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

![](https://2577551913-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MW_FvcY52Jcyt8JHFGs%2Fuploads%2FIl9pxyKA0I0kgzC8hHis%2FTransform_05.png?alt=media\&token=563100d4-41f1-41fd-9f66-36f3993c2a46)