Need help on copy paste in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2068260%22%20slang%3D%22en-US%22%3ENeed%20help%20on%20copy%20paste%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2068260%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3C%2FP%3E%3CP%3EI%20would%20like%20to%20paste%20some%20values%20which%20are%20copied%20from%20one%20column%2C%20but%20the%20condition%20is%2C%20the%20values%20should%20be%20pasted%20keeping%20one%20cell%20blank%20between%20two%20value%20contained%20cells.%3C%2FP%3E%3CP%3ECan%20anyone%20please%20help%20me%20that%20how%20to%20do%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3ESakhawat%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2068260%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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

1 Reply

@Sakhawat1979 

For such sample

image.png

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)),""))