Help with Budget

[Roboter]

Hi guys,

Need your expertise again. I'm trying to allocate our suppliers cost over 12 months. To do this I need a chart ranging from jan to dec.

My question is, how do I intelligently create a chart and then allocated the cost accordingly. Problem is, my list extends to eternity and I cant do each one manually.

Any help is greatly appreciated (see attached example for reference)
Thanks in advance for all of your help. i've attached another example of what the chart might look like, I just want to have an efficient way of producing the charts.

Thanks again