Shifting Multiple Columns up an Increasing number of rows

[GreenApple24]

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!

[Clifford_Coon · Accepted solution]

Hi @GreenApple24 

Here is one way:

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

 

[GreenApple24]

You are a life saver. Thanks for this! I will look into macros as well. I haven't made it that far in my lessons yet. Have a good day!