Forum Discussion
Power Query Unpivot help!
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
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