Table.Unpivot

Syntax

Table.Unpivot(table as table, pivotColumns as list, attributeColumn as text, valueColumn as text) as table

Description

Translates a set of columns in a table into attribute-value pairs, combined with the rest of the values in each row.

Reference Data

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

Power Query M Functions / Table Functions / Table.Unpivot