Shifting Multiple Columns up an Increasing number of rows

Question

Hey there,

I am running into a problem where I want to shift a dynamic amount of columns up a dynamic amount of rows. For example, I want all the data for the 2nd column to be shifted up 1 row, all the data in the 3rd column to be shifted up 2 rows, and all the data in the 4th column to be shifted up 3 rows. I have 50+ columns to do this to so manually shifting the data up is too tedious. Is there a tool to do something like this?

Below is a visual example:

Input: starting file

Output: What I want the file to look like

Thanks in advance for the help!

Supplement 2.xlsx

Clifford_Coon · Accepted Answer

Hi @GreenApple24

Here is one way:

This could be a good place for a macro to present this as one tool.