Need help is using the Summarize tool

EmilAlteryx01

i have this table

Sr.ID	Type	Amount	Advance	Discount
123456	CREDIT	2000	500
123789	DEBIT	4000	10
123789				0.3
123963	CREDIT	300	0	0
123852	CREDIT	4000	1000
123852				0.25
147852	DEBIT	8000	3500
147852				0.15
159753	DEBIT	3500	5	0.1

Results should be like this

Sr.ID	Credit_Type	Debit_Type	Amount	Advance	Discount
123456	CREDIT		2000	500	0
123789		DEBIT	4000	10	0.3
123963	CREDIT		300	0	0
123852	CREDIT		4000	1000	0.25
147852		DEBIT	3500	5	0.1

AndrewSu

@EmilAlteryx01 , I think your end state is missing a row for Sr.ID 159753 and that the values for Sr.ID 147852 are actually incorrect (they are the values for Sr.ID 159753 ).

I believe the below is what you are looking for as the end state.  

Please see the attached workflow to see one path to get to this new table. 

If this helps resolve your issue, please mark this post as the solution so that other's in the community can benefit from our collaboration. 

Thanks. 

For NatzAsh01.yxmd