This question could be a duplicate but I cant find anything that matches my case.
I would like to transpose the whole input table.
When I use the transpose and immediatly the crosstab tool I am able to shift the rows with the columns but I can not have the ID and instead it creates multiple instances of the "Q" field for all the ID.
Input:
Output:
Thanks
Solved! Go to Solution.
Hi @Dennisklad1 I mocked up a workflow that produces the output you describe. Let me know what you think?
You are awesome! Thanks
@Dennisklad1 — Try this solution:
FYI, last two "Dynamic Rename" tools are taken to rename the columns (without using the "Select" tool)