Hi,
I've just started to use Alteryx Designer and have run into some issues regarding creating a "pivot" table from an output of a workflow which I created. I've attached an excel file with the first tab for the data (# of VAR columns can differ depending on data), and a second tab for the desired results. I've tried numerous Transform functions including combining them, but just can't seem to produce the table needed. Thanks.