# 9. Data transformations

Transform your data within Infobridge - add dimensions and measures, pivot columns, sort, filter, and format your data. Perform all these operations without modifying your source visual.

Let's explore the transformations available in Infobridge.

| TRANSFORMATION                                                                                                      | DESCRIPTION                                                                                             |
| ------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------- |
| [Pivot table](https://docs.inforiver.com/infobridge-wb-matrix-only/9.-data-transformations/pivot-table)             | Restructure your dimensions and measures to align with the target report.                               |
| [Group by](https://docs.inforiver.com/infobridge-wb-matrix-only/9.-data-transformations/group-by)                   | Summarize and aggregate your detailed data for crisp high-level reports.                                |
| [Add column](https://docs.inforiver.com/infobridge-wb-matrix-only/9.-data-transformations/add-column)               | Add calculated measures and custom dimensions.                                                          |
| [Pivot column](https://docs.inforiver.com/infobridge-wb-matrix-only/9.-data-transformations/pivot-column)           | Convert row values from one column into multiple columns.                                               |
| [Unnest](https://docs.inforiver.com/infobridge-wb-matrix-only/9.-data-transformations/unnest)                       | Flatten your comma-separated data into multiple rows.                                                   |
| [Rename column](https://docs.inforiver.com/infobridge-wb-matrix-only/9.-data-transformations/rename-column)         | Change the name of any dimension or measure.                                                            |
| [Find and replace](https://docs.inforiver.com/infobridge-wb-matrix-only/9.-data-transformations/find-and-replace)   | Search for a string or value and replace it with another.                                               |
| [Remove measure](https://docs.inforiver.com/infobridge-wb-matrix-only/9.-data-transformations/remove-measure)       | Remove selected measures from the query.                                                                |
| [Filter rows](https://docs.inforiver.com/infobridge-wb-matrix-only/9.-data-transformations/filter-rows)             | Remove redundant rows that do not match the specified filter condition.                                 |
| [Sort](https://docs.inforiver.com/infobridge-wb-matrix-only/9.-data-transformations/sort)                           | Apply a custom sort order for measures and dimensions.                                                  |
| [Text functions](https://docs.inforiver.com/infobridge-wb-matrix-only/9.-data-transformations/text-functions)       | Extract and format text data.                                                                           |
| [Unnest](https://docs.inforiver.com/infobridge-wb-matrix-only/9.-data-transformations/unnest)                       | Convert delimited values into separate rows and flatten your data.                                      |
| [Round](https://docs.inforiver.com/infobridge-wb-matrix-only/9.-data-transformations/round)                         | Round numeric data to a specified number of decimal places.                                             |
| [Extract Comments](https://docs.inforiver.com/infobridge-wb-matrix-only/9.-data-transformations/extract-comments)   | Extract cell-level comments from the source report into a separate column.                              |
| [Import and export](https://docs.inforiver.com/infobridge-wb-matrix-only/9.-data-transformations/import-and-export) | Export and download transformation steps and import them into another query to re-apply the same steps. |