Hi
PLease help (new b)

I want to split data of a shipment into multiple rows, based on the a standard pallet quantity
E.G.
1) SKU: 807020450043 BATCH: 41826790 QTY: 15600
(PALLET QTY 1560)
2) SKU: 807580450044 BATCH: 41452190 QTY: 5760
(PALLET QTY 576)
I want to split the row by the pallet qty, will result in 10 rows of 1560 / 576
Data will look like this
807020450043 41826790 15600
807580450044 41452190 5760

Thanks Ashlee