Move data through a series of columns to show week over week changes

SeanPM

I have a column with the current week's data in it. This is pulled programmatically each week. I'd like to be able to move that data over to a new column each week before the api kicks in so I can compare week over week performance. So

Col A: Data from this week pulled in on Weds

Col B: Data from the previous week copied over via automation or formula

Col C: Data from 2 weeks ago

Col D: Data from 3 weeks ago

Col E: Data from 4 weeks ago

To complicate things further, I'd like for the data to be rolling. So the data from col E drops off each week and is replaced by the data from col D and so on.

Is this achievable?

Thanks

Paul Newcome

You MAY be able to accomplish this through the API.

How many rows do you need this kind of functionality for?

SeanPM

Approximately 1,000

Paul Newcome

Would it work if you had more week columns that didn't shift and then you use a formula in another column to show the current week?