Moving data to another cell by a certain amount of columns

[UxR]

Hi everyone,

I'd like to explain what this table needs to provide.
We have the monthly revenues by product, but the billing time for that revenue is a number of months away.
How many months, depends on the product.
So, what I need is for example move January revenue of Product A (let's assume Product A's billing time is 2 months) to March column in the table above.
I've attached a screenshot, the gray table needs to be filled. Billing cycles are on the right.
If only there was a =MOVE function that can easily do that.
Could anybody please help? If you need to use a macro for this, could you also give some directions on how to use it.
Thank you!

 

[dermie_72]

in cell B3 use =IF($P13=1,$B$13,""), Drag that to the right, and increment the 1, then drag it down to row 9. That should populate the information in the field you want.