ResultingMatrixShortcutDescription

  • Columns represent all unique values from the selected columns (they become column groups corresponding to value combinations when using then, similar to pivot);

  • Rows correspond to all unique combinations of values from the grouping columns; each combination is represented in dedicated key columns that store a distinct set of values for each row (similar to keys in GroupBy).