Separate equal records into multiple excel files

[argon15]

Hi everyone,
I apologize but I was unable to find a solution to my problem in the forum. 
In practice I would have to divide the records having the same order number 
into several files as in the example I am attaching. 
There's a way?
Thanks for your patience

[Anonymous]

Hi

Iterate each record and set a dynamic output file path, see below.

 

Regards

Shong