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