Table.Pivot

Syntax

Table.Pivot(table as table, pivotValues as list, attributeColumn as text, valueColumn as text, optional aggregationFunction as nullable function) as table

Description

Given a pair of columns representing attribute-value pairs, rotates the data in the attribute column into a column headings.

Reference Data

https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference

Power Query M Functions / Table Functions / Table.Pivot