Hi,

Sorry if this has been already solved in some other thread but I've been unable to find it.

Basically I have an spreadsheet with skus in column A (say 'baseball bat', 'baseball cap', 'baseball jacket'...) and a qty in column B (i.e. 300, 200, 150...).

Is there a way to split row 1 'baseball bat' = 300 resulting in 8 rows (1 to 8) 'baseball bat' = 60, then row 2 (now row 9) 'baseball cap' = 200 in 4 rows 'baseball cap' = 50, and so on...

Thank you.