Converting a small amount of data into a row

[Kalamari]

I have a table with parts in a box and number of boxes.

I need to show in a row each box in its own column, eg.

3 x boxes of 50 and one box of 12 plus one box of 34

needs to display as...

50 50 50 12 34

I've got a formula that can do the first part using column number as an index for full boxes, the second part is eluding me, I'm hoping there's an odd formula command in excel that will help.

=IFERROR(IF($M2>=B$1,$N2,""),"") N2 is total parts per box, M2 is total boxes

Example attached below...

[Bo_Ry]

Please try at B2

=IF(COLUMNS($B2:B2)>$M2,IFERROR(1/(1/INDEX($O15:$R15,COLUMNS($B2:B2)-$M2)),""),$N2)

[Kalamari]

Thank you, you are a genius absolutely what I needed.