Forum Discussion
Power Query Unpivot help!
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
Anonymous , refer if this blog can help
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
3 Replies
Anonymous , refer if this blog can help
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