Adding blank rows in a set of data in Google Sheet

问题:

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

回答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("