Skip to content
REFERENCE

U.TABLE_TO_GRID

Summary

Converts a table of data into grid form

Syntax

=U.TABLE_TO_GRID(table, row_labels_cols, col_labels_cols, value_column, [keep_col_labels], [do_not_sort])

Parameters

Parameter Required Description
table Yes The table of data to be transformed into grid form
row_labels_cols Yes The name and/or index of the table column(s) whose values will be used as row labels in the grid. If more than 1 provided, the order provided will dictate the order in which they appear in the grid. An asterisk ("*") indicates all non-column, non-value columns
col_labels_cols Yes The name and/or index of the table column(s) whose values will be used as column labels in the grid. If more than 1 provided, the order provided will dictate the order in which they appear in the grid
value_column Yes The name and/or index of the table column whose value will be used as the grid values. Optionally enclose in a supported function to change how duplicate rows are aggregated into the grid value
[keep_col_labels] No Set to TRUE to have the table's column labels, if any exist, persisted in the top-left portion of the grid. Provide TRUE/FALSE values in a 2-column array to set independently for row labels and column labels
[do_not_sort] No Set to TRUE to prevent the grid being sorted vertically by row labels and horizontally by column labels. Provide TRUE/FALSE values in a 2-column array to set independently for row sorting and column sorting. Use -1 for descending sort

Behavior

The documented public interface is supported by the current U Add-in source signature and the maintained Usage Examples workbook. Optional parameters are shown in square brackets in the syntax above; omit the brackets when entering a formula.

Return Value

Returns the function result or action status described by the formula and parameters above. The maintained sources do not define a narrower, stable return contract for this function.

Examples

=U.TABLE_TO_GRID(U.GRID_TO_TABLE(B157:I161),{1,2,3},4,5)

=U.TABLE_TO_GRID(B169:D178,"Symbol","Date","Estimate")

=U.TABLE_TO_GRID(B183:F219,"Time,Symbol","Firm,Date","Estimate")

Notes

  • Formula examples are preserved from maintained workbook usage and normalized to the current U. prefix.
  • Complete formulas demonstrate working patterns; they do not imply that undocumented option values are supported.
  • Where maintained sources do not specify every accepted value, default, or error message, this page does not infer one.
  • For functions that perform actions, use a visible trigger or supported block/throttle parameter to avoid unintended repetition during recalculation.