Forum Discussion
Convert a single column to multiple table columns
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:
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:
I have the same problem and i was wondering how did you get the "value" column?