Copy every nth row and Insert the copied value every nth row

anakin1982 · Apr 7th 2020

Hi all,

newcomer.

I have this kind of data

I want the value found in every 4nd row (beginning from the 2nd row) to be copied and inserted every 4nd row and have this outcome:

is that possible?

Thanks in advance!

bosco_yip · Apr 9th 2020

Try.......

1] "Source table" housed in Column A and B, and "Result table" housed in column D and E

2] In D2, formula copied right to E2, and all copied down until blank:

=IFERROR(INDEX(A$2:A$10,INT(ROW(A2)/4)*3+MOD(ROW(A2),4)-1),"")

Regards

Participate now!