1/ Export without any filter,  result example:

 

 

 

 

 

 

 

 

 

 

 

 

2/ Now we set filter “Group by” to Product ID. Result:

(Product ID 5 is present only in Order No 4, other products are in more Orders. “Group by” filter sum Quantity, Weight and Price, but not Order No or Product name. This is why is “Absurdity” in some fields. But see next filter setting. )

 

 

 

 

 

 

3 / Set  filter (2)     “Group by: Add multiple values”, and result:

(see for example Product ID 2,  fields “Order No” and Name)