Forum Discussion
Solved
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 amo...
=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.