May 13 2021 01:14 PM
Hello All,
I have a spreadsheet with columns which point to 30 day apart, that is; 0-30 days, 31-60 days, 61-90 days and so on.
I want to be able to put in data on the first column(0-30days) and get it to transfer to the next column (31-60 days) and subsequent columns after 30 days
Is there a formula to do this?
Thanks
May 15 2021 05:37 PM
You are talking about not just one formula but a whole selw of them, plus power query, plus power pivot plus data modeling etc etc.
Start with learning power query then proceed to power pivot and data modeling
after that you can create a data modeled power pivot that will display your data in whatever manner you would like automatically