Forum Discussion
Convert a single column to multiple table columns
I’m still fairly new at PBI, and find it’s a great tool, especially since we often work with millions of records, but I do have a situation I need some help with. I have a table in which I may ha...
Anonymous Steps to take in Edit Queries
1) Highlight "Value" column and under the Transform toolbar click "Unpivot Columns"
2) Go to Add Column tool bar - click "Index Column" (this will add an index column to your dataset
3) Highlight the Attribute and Index columns, right click and "Merge Columns" (Pick a delimiter)
4) Hightlight the Value and Merged columns, go back to the Transform toolbar, click "Pivot Column"
the "Value" column should be in the Values Column selector, click open Advanced options -> select "Don't Aggregate" from the dropdown. - click OK
Your output should look like this:
dramus
Continued Contributor
Continued ContributorLooks like you are trying to pivot the table.
- What problem are you trying to solve?
- Is there any logic behind the identifiers?