Help Setting Up Data

[liquidicem]

I need some help setting up my data for easy future analysis. I need to track forecasted and actual spending by purchase order number and department number.

Purchase orders have a unique number and all point back to a set of fixed department numbers.

Purchase orders can be invoiced more than once so spending can hit in multiple quarters.

Right now I have a column for purchase order number, a column for department number, and column for every month for the next 2 years. I'm putting the forecasted spending for each purchase order under the month its expected to hit.

I don't think this is the best way to organize this data. I'd like to be able to quickly work with it in a Pivot Table but that won't work with a column for each month. I think I would have to have a separate entry in my table for each spending occurrence for each purchase order. So one purchase order would have to have 3 different entries if spending was going to land in 3 different quarters.

I also have no way to track actual spending by quarter without adding a separate entry for each purchase order.

Any thoughts on how I can better organize this data would be greatly appreciated. Thanks!