Forum Discussion
Cyressvirus
Jan 23, 2025Copper Contributor
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.
- CyressvirusCopper Contributor
Your a genius !! Ty so much, you just saved me hours and hours of work !! It work flawlessly
You guys, should participate in Excel Esport (Microsoft Excel
World Championship) - OliverScheurichGold Contributor
=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.