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

Solve of transpose.yxmd

JosephSerpis

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

Transpose_Crosstab_30092020.yxmd