Power Query Unpivot help!

[Anonymous]

Hi there,

I have data which I need to unpivot as shown below:

Please note there are many customers and attibutes, so I don't want to split into seperate queries! is it possible within a single query?

Thank You so much!

Alex

[amitchandak · Accepted solution]

@Anonymous , refer if this blog can help

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

[TomMartens · Accepted solution]

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

[amitchandak · Accepted solution]

@Anonymous , refer if this blog can help

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

[Anonymous]

Thank you I was able to solve my problem with the help of this link! 🙂