Multiple information columns prior to Time Periods columns
Asking for some general advice on how best to manage this.
We have several schedules in Excel which show mutliple information columns prior to the Time Period Columns. Eg.
Project Name | Project Type | Product | Start Date | End Date | Jan 22 | Feb 22 | Mar 22 | Apr 22| etc.....
There are several tables like this that I would then like to have a consolidated report which picks up the total of each of these schedules which all have the line item months in common but not necessarily the other line items (although they do have common dimensions).
I am struggling to work out the best way to approach this as if I use actual time periods then I cannot show these information columns that the user requires to be able to enter the appropriate forecast amount in the time columns.
Any advice would be greatly appreciated.