Transpose table with fixed column

[Dennisklad1]

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

[JosephSerpis · Accepted solution]

Hi @Dennisklad1 I mocked up a workflow that produces the output you describe. Let me know what you think?

[Dennisklad1]

 You are awesome! Thanks

[vizAlter]

@Dennisklad1 — Try this solution:

FYI, last two "Dynamic Rename" tools are taken to rename the columns (without using the "Select" tool)