Data shaping problem

[miro_x]

I want my data below to display two columns, one for Attainment grade and another for Effort grade so that I can treat them as independent data types. Any suggestions on how best to achieve this? The only thing I can come up with is to copy the huge table (there are over 20 columns) two times, filter one to display "Attainment grade" and the other to display "Effort grade" only in the query editor and then join them via a relationship, this feels really messy, so I want a better approach to this.

Current state of data

[Iamnvt · Accepted solution]

hi,

you can use "Pivot" transformation in Power Query.

Here is the PBI file.

https://1drv.ms/u/s!Aps8poidQa5zk6pYUByuTq3fkWeCRQ

[miro_x]

Thank you that is great! I am curious why did you bother with adding the index column?