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 · Accepted solution]

@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. 

[flying008]

Hi, @EmilAlteryx01 

1- Maybe there is a easy way like @AndrewSu :

2- If you have many types like N > 3 more than "CREDIT" and "DEBIT", there is a smart solution to avoid manual fill formula again.

******

If is can help you get want output, please mark it as s solution and give me a like for more share.

[EmilAlteryx01]

Thank you soo much ..

This Worked :)