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:
Thank you so much Eno1978!!! I'd been wrestling with it for a week, so you were a huge help! I'd danced around the indexing on several tries, but didn't think to merge.
- Is there a response missing from this thread now? The previous message says 'Thanks Eno1978..' but there is no message from Eno1978 and the Accepted Solution seems to be only a partial solution. Is it possible to squash the table back up, so that it doesn't run to hundreds of columns? Thanks.
Anonymous Eno1978 was my old handle. I changed it. I assume you have a different use case that this solution does not work for? I would suggest that you create a new post that references this one if it is close, but different. That way people that answer all questions will recognize it as a new thread instead of just someone posting on an old "solved" thread.
Anonymous I've applied the same steps for the below scenario which is not giving me the expected result. Is it different from the above.