Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How can I take the 2 Inputs shhets from the attached to make a Pivot

EmilDem01
8 - Asteroid

Input 1 Subject and Input 2 Fees 

Outcome in one Excel - different worksheets

3 REPLIES 3
binuacs
20 - Arcturus

@EmilDem01 one way of doing this

image.png

EmilDem01
8 - Asteroid

Thank you Soo much

i made a few changes to my input

i hav e attached sheet 2 of the final pivot..

How do i remove the Null and get a summary in one table (information one below the other)

binuacs
20 - Arcturus

@EmilDem01 I added the below steps for your extra output

image.png

Labels