Welcome to Excel Jet Consult blog post. In this tutorial, we want to learn how to unpivot columns in Power BI Power Query
Unpivot Columns translates all but the currently unselected columns into attributes -value pairs. We want to unpivot the data in the Power BI Power Query of the caption below
To unpivot other columns:
Select Qtr 1 to Qtr 4 columns
In the Transform group of the data tab, click on Unpivot Columns
We can see that all the Account Managers name are listed in alphabetical order as well as the corresponding Q1 to Q4.