Terminology Given a base table, choose three columns, * pivot_row * pivot_column * pivot_value such that for each pair of values from (pivot_row, pivot_column), there is at most one distinct pivot_value. A pivot table has : * one column whose values are the distinct values in pivot_row * other columns corresponding to distinct values of pivot_column * the values in those columns correspond to the unique values in pivot_value for the corresponding column and row value.