Power Query

Hi Anonymous ,

According to your description, here's my solution.

1.Select columns from A to F, then click Unpivot Columns.

Result:

2. To sort the month name column, add a custom column:

if [Month name]="jan" then 1 else if [Month name]="feb" then 2 else if [Month name]="mar" then 3 else if [Month name]="april" then 4 else 5

Sort Month name column by MonthNo column.

In a matrix, put Code in Rows, Month name and Attribute in Columns, get the result:

I attach my sample below for your reference.

Best regards,

Community Support Team_yanjiang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.