Adding blank rows in a set of data in Google Sheets

Question

I have a set of data. What i am looking forwards is to add 2 blank rows after each set of 3 values like this

Hope to get help in getting this solved.

you can find the sample google sheet here : https://docs.google.com/spreadsheets/d/11nMvUWn3xcTfxlk4v30KruPr03HSheMk1jrxZPpJ_p4/edit?usp=sharing

Thanks

Shijilal

Answer 1

Solution:

• IF it's the third row, Add 3 bunnies separated by a space, else keep the values as it is
• JOIN them all and SPLIT by a bunny and TRANSPOSE

Sample:

=ARRAYFORMULA(TRANSPOSE(SPLIT(TEXTJOIN("🐇",1,IF(MOD(ROW(A2:A16),3)=1,A2:A16&REPT("🐇 ",3),A2:A16)),"🐇")))