The ColumnCross class creates a single row for all represented values of each row identifier. The arrangement contains a column for each row identifier and for each value represented by the CrossColumn attribute of the CrossTable class.

The following table provides an example of a data set that contains one row identifier (the Key_ID column), values that populate the CrossColumn attribute (the Color column), and aggregate values that represent the data to be returned (the Aggregate column):

The following table provides an example of a ColumnCross arrangement based on the preceding data set:

Null is returned for each column/row intersection that contains no aggregate value.