Jan 17 2021 01:42 AM
Hi!
I would like to paste some values which are copied from one column, but the condition is, the values should be pasted keeping one cell blank between two value contained cells.
Can anyone please help me that how to do it?
Thanks
Sakhawat
Jan 17 2021 05:17 AM
For such sample
I'd use formula as
=LET(range, A2:A1000, k, COUNTA(range), n,SEQUENCE(3*k/2),IF(MOD(n,3),INDEX(range,n-INT(n/3)),""))