Forum Discussion
Need help on power query
First, select all columns and choose to "Unpivot Columns" (found on the Transform tab). This will unpivot your table to look like this:
From here, split your Attribute column by delimiter (.) to get the question number and the category into separate columns (you can then simply delete the column that references "Column1" in all rows. Should end up looking like this:
Finally, select your "Attribute.3" column (or whatever the column name ends up being for your categories: question, options, answer) and choose to Pivot the table by the "Value" column along with choosing not to aggregate. See screenshot below:
This should give you your desired result:
@drewlewis15 perfect!!!! :)
looks great.... Thanks a ton... (y).
First, select all columns and choose to "Unpivot Columns" (found on the Transform tab). This will unpivot your table to look like this:
From here, split your Attribute column by delimiter (.) to get the question number and the category into separate columns (you can then simply delete the column that references "Column1" in all rows. Should end up looking like this:
Finally, select your "Attribute.3" column (or whatever the column name ends up being for your categories: question, options, answer) and choose to Pivot the table by the "Value" column along with choosing not to aggregate. See screenshot below:
This should give you your desired result:
@drewlewis15 perfect!!!! :)
looks great.... Thanks a ton... (y).