Multi-Row and File Combine

[NatzAsh01]

Hi, 

I would like a combine Output

Input file attached and Part of the Workflow

Multiple rows data should be Grouped by the Sr.ID

End Result - should be as below - 

Sr.ID	Arrivals	Sale	Version	Type	Amount	Advance	Discount
123789	Last Season	Sale Item	1	CREDIT	4000_USD	0	0.3
123852	Last Season	Sale Item	1		1000_GBP;350_GBP
147852	Last Season	Sale Item	1		8000_USD		0.25
159159	Last Season	Sale Item	1	CREDIT	2000_USD;500_USD	0
159753	Last Season	Sale Item	1		1000_GBP
232323	Last Season	Sale Item	1	CREDIT	7550_USD;1000_USD	-0.35
111133	Last Season	Sale Item	1	DEBIT	6000_EUR;350_EUR	-500
874125	Last Season	Sale Item	1	DEBIT	5000_EUR	0	0.05
222159	Last Season	Sale Item	1		5000_USD;500_USD;50_USD	0	0.25;0.1
963741	New Arrivals	Sale Item	1	DEBIT	3000_USD	500	0.25
159712	New Arrivals	Sale Item	1	CREDIT	2500_USD	250	0.1

[Qiu]

@NatzAsh01 

I hope this will work for you.

[binuacs · Accepted solution]

@NatzAsh01 One way of doing this

[NatzAsh01]

The outcome should have only 11 rows 

When i do this Manually in excel - i first 

1) Filter the Arrivals into "Last Season" and "New Arrival" 

2) The from the "New Arrivals column : - i filter further to Items on Sale and Non-Sale (as the output should only include Sales items)

Also - 

The outcome is missing (Maybe becuz it does not have a Type) but i need that in my Output Sr. ID - 123852

Sr.ID	Arrivals	Sale	Version	Type	Amount	Advance	Discount
123852	Last Season	Sale Item	1		1000_GBP;350_GBP

[binuacs · Accepted solution]

@NatzAsh01 updated my workflow to reflect the correct input file sort order