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

  • Hi all,

    newcomer.


    I have this kind of data



    DATA 1
    DATA 2
    1A
    1B
    1C
    2C
    2D
    2E
    3E
    3
    F
    3G



    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:


    DATA 1DATA 2
    1A
    1B
    1B
    1C
    2C
    2D
    2D
    2E
    3E
    3F
    3F
    3G





    is that possible?



    Thanks in advance!