I have a workbook that I need to use to upload files automatically to a point, basically, it resolves around taking a sku from master sheet A2 and then copying it exactly six times on a different sheet before moving to A3 and copying that SKU 6 times.
Right now I am using an array formula to just autofill, so I would want it something like that, but just copy 6 times for each filled cell. I used the following for different sheets to autofill.
=ArrayFormula(Magento!A2:A)
Array formula wouldn't work for my image tab, Here is a copy of the sheet I already populated by hand, but basically it is from the first sheet tab, Magento and going to the Image_Extras sheet. Each Sku needs 6 rows for 6 image positions.
https://docs.google.com/spreadsheets/d/107Va2LStSyz3My7Jcb9di4DsZtt_am40_grg0q_wIXQ/edit?usp=sharing
