Shift data to Right and insert new columns

Question

Hi all,

I have an existing excel file with years of data on it. Each year I need to insert a new column and have all the data shift to the right, and insert the new data in column B. I need to insert two comparison columns as well in F & G each year and have comparison data shift to the right as well. I am trying to do this without selecting all the data in the file as it is formatted and simply just insert blank columns that I can input the new data in, in columns B,F&G. Sample file attached with original and needed output.

Sample Data.xlsx

h_kleine · Answer

Not very elegant, but maybe you can use this as a start. You'll probably need to build a macro since your number of years in the input is unknown.

demo.yxmd

mceleavey · Answer

Hi @lomeoari ,

It appears this can't be done automatically with the data you've provided. You say you need to insert a new column with, in this example, 2022 data, but you don't provide how that is derived, so I assume you need to add this manually and have Alteryx calculate the others.

Alternatively, is the new 2022 column being added at source and this then needs to be used in the following calculations?

M.