Duplicate Column and Shift

I am trying to take a column and duplicate it, but I need to remove the top value and shift everything up by 1 and duplicate the last value. The process is like an upside down staircase and duplicates 39 times. It would also be very helpful to have an example of one that duplicates and does the process 60 times as well.

Book1.xlsx

Workflow

Optimization

Accepted answers

geraldo

@mquast

I attach the iterative macro developed by @JamesCharnley to configure the number of times you need;
click on the macro and configure the amount.

I made some adjustments to get the last record so it doesn't get null

duplicateandskipone.yxmc

All comments

JamesCharnley

Hi @mquast

Sounds like you'll need an iterative macro for this one. I've attached a workbook that shows you how it should work. It's essentially just taking the column that has most recently been skipped, skipping the first record again and joining it back on record position. The other tools are to match the naming convention of your output.

IterateDuplicateColumns.yxzp

mquast

@JamesCharnley This is awesome, how would I modify this to duplicate 60 times?

geraldo

@mquast

I attach the iterative macro developed by @JamesCharnley to configure the number of times you need;
click on the macro and configure the amount.

I made some adjustments to get the last record so it doesn't get null

duplicateandskipone.yxmc

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703