Transfer data from one column to another column on a certain date

%3CLINGO-SUB%20id%3D%22lingo-sub-2352711%22%20slang%3D%22en-US%22%3ETransfer%20data%20from%20one%20column%20to%20another%20column%20on%20a%20certain%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2352711%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20All%2C%3C%2FP%3E%3CP%3EI%20have%20a%20spreadsheet%20with%20columns%20which%20point%20to%2030%20day%20apart%2C%20that%20is%3B%200-30%20days%2C%2031-60%20days%2C%2061-90%20days%20and%20so%20on.%3C%2FP%3E%3CP%3EI%20want%20to%20be%20able%20to%20put%20in%20data%20on%20the%20first%20column(0-30days)%20and%20get%20it%20to%20transfer%20to%20the%20next%20column%20(31-60%20days)%20and%20subsequent%20columns%20after%2030%20days%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20formula%20to%20do%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2352711%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2357756%22%20slang%3D%22en-US%22%3ERe%3A%20Transfer%20data%20from%20one%20column%20to%20another%20column%20on%20a%20certain%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2357756%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1053330%22%20target%3D%22_blank%22%3E%40IsimiKehinde%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20are%20talking%20about%20not%20just%20one%20formula%20but%20a%20whole%20selw%20of%20them%2C%20plus%20power%20query%2C%20plus%20power%20pivot%20plus%20data%20modeling%20etc%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EStart%20with%20learning%20power%20query%20then%20proceed%20to%20power%20pivot%20and%20data%20modeling%3C%2FP%3E%3CP%3Eafter%20that%20you%20can%20create%20a%20data%20modeled%20power%20pivot%20that%20will%20display%20your%20data%20in%20whatever%20manner%20you%20would%20like%20automatically%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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

1 Reply

Hi @IsimiKehinde 

 

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