Assistance with Pivoting Dataset in Alteryx

Hi,

As part of a project, every dataset to be consumed is formatted like this:

And I need it formatted like this:

This obviously needs more than just the pivot tool. Is this something that can easily be done in Alteryx? I've attached a sample dataset.

Alteryx Sample Dataset.xlsx

Preparation

Accepted answers

This should do it

Alteryx Sample Dataset.yxmd

Here is solution for your case. Hope this is helpful.

Assistance with Pivoting Dataset in Alteryx.yxzp

All comments

This should do it

Alteryx Sample Dataset.yxmd

Here is solution for your case. Hope this is helpful.

Assistance with Pivoting Dataset in Alteryx.yxzp

This worked perfectly and was exactly what I was looking for!

I like the logic behind the workflow. Thank you again!

This solution also worked, so thank you for sending that through! The first solution just appeared slightly more elegant but I guess that is very subjective.

Thanks again.

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703