# Time-Series Matrix Transformation

"Time-series matrix transformation" is a feature that transforms records stored in a related list of the Salesforce object from list form to matrix form, using a time-series field as an axis, and align them horizontally as same as the fields in the original Salesforce object in the sheet.

In addition, inputted/updated data on the sheet is automatically transformed inversely from matrix form to list form when saving in Salesforce, which makes it possible to establish user-friendly data entry while maintaining the optimal database structure for reporting.

{% hint style="success" %}
Your organization must be enabled the "Matrix Transformation Option" to use this feature. If you wish to use it, please let us know to the sales representative in charge.
{% endhint %}

## [Overview](https://docs.mashmatrix.com/mashmatrix-sheet/functions_advanced/time_series_matrix_transformation/overview) <a href="#overview" id="overview"></a>

## [Add Matrix Column](https://docs.mashmatrix.com/mashmatrix-sheet/functions_advanced/time_series_matrix_transformation/add_matrix_column) <a href="#add-matrix-column" id="add-matrix-column"></a>

## [Change Matrix Column Setting](https://docs.mashmatrix.com/mashmatrix-sheet/functions_advanced/time_series_matrix_transformation/change_matrix_column_setting) <a href="#change-matrix-column-setting" id="change-matrix-column-setting"></a>

## [Show / Hide Column](https://docs.mashmatrix.com/mashmatrix-sheet/functions_advanced/time_series_matrix_transformation/show_hide_column) <a href="#hide-show-column" id="hide-show-column"></a>

## [Add Child Columns](https://docs.mashmatrix.com/mashmatrix-sheet/functions_advanced/time_series_matrix_transformation/add_child_column) <a href="#add-child-column" id="add-child-column"></a>

## [Delete Child Column](https://docs.mashmatrix.com/mashmatrix-sheet/functions_advanced/time_series_matrix_transformation/delete_child_column) <a href="#delete-child-column" id="delete-child-column"></a>

## [Format](https://docs.mashmatrix.com/mashmatrix-sheet/functions_advanced/time_series_matrix_transformation/format) <a href="#format" id="format"></a>

## [Limitations](https://docs.mashmatrix.com/mashmatrix-sheet/functions_advanced/time_series_matrix_transformation/limitations) <a href="#limitations" id="limitations"></a>
