Power Query Unpivot help!

Anonymous , refer if this blog can help

https://kohera.be/blog/power-bi/how-to-unpivot-twice/

Hey Anonymous 

to achieve what you want, you need three steps.

This is how my sample data looks like

First step, unpivot the columns CA-A1 - CX-AX then your table will look like this:

Second Step - Split the column Attribute in 2 columns:

select the proper delimiter, maybe it's " - " on your data, here it's just the dash, after that your data will look like this:

Third step
Mark the column that contains all the attributes, here its Attribute.2 and Pivot the column, choose Value column for the values:

Hopefully, this provides what you are looking for.

Regards,

Tom