Unpivot columns in Power Query Editor in Power BI

In Power Query, we can transform columns into attribute-value pairs, where columns become rows. Unpivoting is a useful feature of Power BI.

Power Query will always create the attribute-value pair by using two columns:

• Attribute: The name of the column headings that were unpivoted.
• Value: The values that were underneath each of the unpivoted column headings.