spliting a row on excel

[Ashleeg]

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

[boopathiraja]

Try with in data menu> text to column> delimit > space> finish

[Ashleeg]

Hi
Thanks
But this not what I am looking for
I want to split the row into multiple row accoring to the pallet qty

[boopathiraja]

Could u post a sample file