Hey! I have a problem transforming my dataset in alteryx. It's a fairly long time ago, i've been working with the crosstab and transpose tool, so it might be obvious to some what the solution is.
However, my dataset looks like this (also appended)
And I would like the data to be transformed to look like this:
Can anybody help here?
You just need to use the Transpose Tool. Select everything as key fields except those that you want to go from wide to tall, i.e. Assistant and Manager,