You may not want to hear about a work-around, but you could insert the longer BOM, arrange the rows vertically like you want, and split the table. Then copy and paste the sheet, and drag the top section off the sheet on one of them, and drag the bottom section off the sheet on the other one.
I know that's far from an ideal solution, but I don't know of a better way.
Edit: I went back and played with it. You could delete the upper portion of the table from one sheet and the lower from the second sheet instead of dragging them off the sheet.
Thank you, that will work for now