Creating Pivot Table

[nat0028]

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.

[vizAlter · Accepted solution]

@nat0028 — Welcome to the Alteryx Discussion!

Try this solution:

[ImadZidan]

Hello @nat0028 ,

May be this will help.

[nat0028]

Tnx.  This helps.

[vizAlter]

@nat0028 — Thank you!