enter image description here How can I input data in column F with 4 consecutive data for each data like column E using the data in column D2:D?
Is it possible?
How should I modify the formula in F2?
=ARRAYFORMULA(IF(MOD(ROW(F2:F)-1,4)>0,{D2:D;D2:D;D2:D;D2:D},""))
Let me know if you have any other questions.
If I input data in column B , set consecutive data for each data in F2:F like E2:E.