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

[EmilAlteryx01]

Input 1 Subject and Input 2 Fees 

Outcome in one Excel - different worksheets

[binuacs · Accepted solution]

@EmilAlteryx01 one way of doing this

[EmilAlteryx01]

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]

@EmilAlteryx01 I added the below steps for your extra output