Forum Discussion

Cyressvirus's avatar
Cyressvirus
Copper Contributor
Jan 23, 2025

Skipping cell while pasting data

Hi, 

I'm trying to figure out if there's a way to skip cell at constant interval while pasting Huge amount of data. Something that will act as a pasting template/guide 

eg.: I need to copy huge amount of data (around 5000 cell) in a row but I need to let 2 blank cell every 5 Data cell.

So lets say column C is where I want to paste the data, but I need it to skip cell C7,C8 and then C14,C15 (and so on) while pasting the data. 

like this:

Thank you

  • =LET(block,5,

    rng,A1:B1000,

    IFNA(DROP(REDUCE("",SEQUENCE(1,ROWS(rng)/block,1,block),

    LAMBDA(u,v,

    VSTACK(u,

    CHOOSEROWS(rng,SEQUENCE(1,block,v)),

    "",

    ""))),

    1),""))

     

    With Office 365 or Excel for the web this formula returns the intended result in my sheet. You can dynamically change the variable "block" from 5 to e.g. 7.

     

  • =LET(block,5,

    rng,A1:B1000,

    IFNA(DROP(REDUCE("",SEQUENCE(1,ROWS(rng)/block,1,block),

    LAMBDA(u,v,

    VSTACK(u,

    CHOOSEROWS(rng,SEQUENCE(1,block,v)),

    "",

    ""))),

    1),""))

     

    With Office 365 or Excel for the web this formula returns the intended result in my sheet. You can dynamically change the variable "block" from 5 to e.g. 7.

     

Resources