trying to get better formula to copy select data from column d and paste to column g with no empty cells my current formula works, but leaves blank cells like original column. Current formula =ArrayFormula(if(ArrayFormula(mod(row(D3:D28),4))=3,D3:D28,))

CodePudding user response：

Try this:

How about using =filter instead of =arrayformula.

=filter(D:D, D:D <> "")

or

=filter(D:D, D:D > 0)

CodePudding user response：

or query:

=QUERY(D:D; "where D is not null"; )