Pivot Data

Pivot data turns the unique values within one column of a table into the column name(s) for the resulting column(s).

The values within the Person Column are pivoted to be columns in the resulting table.

Aggregations

Pivot Data can then perform aggregation calculations on the resulting column values based on the selected aggregation type.

Along with None, the available aggregations include:

• Count

• Count (Including Nulls)

• Count Distinct

• Count Distinct (Including Nulls)

• First Value (Ascending or Descending)

• Last Value(Ascending or Descending)

• Sum

• Average

• Median

• Standard Deviation (Partial Sampling or Entire Population)

• Variance (Partial Sampling or Entire Population)

The count functions result in a number value in the generated columns, and the Value functions result in the First or Last value depending on sorting result.

Implementing Pivot Data

Select the desired column(s) to show as rows. This will maintain the selected column header(s) in the resulting table.

Next, select Column Values to Show as Columns.

Input the new column names based on the values within the column. Verb will search the selected column for the matching value and creates a new column using the input value as the column header.

Finally select the value column to display. In the example below, this is the Miles run for the week.