question - amount to auto split in to few months or one year in Excel? is it possible?

[bbsin]

hi

I have a question

In powerApps under is  section total amount that sometime needs to split into months or even  one year till next year ...I want to be able to have the user tick one or two selection and it will auto split in Excel file not into the SP list.  the  SP list is showing the total amount with the date/month column. 

Is there a way to do it or with workflow?  can advise.?  Thanks.