Transform

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