I wish to prepare a pivot table so I can prepare a cash-flow of expenditure over each year for different criteria.
The data I have been given shows the expenditure each year. (refer Table 1 in 'Data' sheet on attached Example file)
But Im not sure how I can create a pivot table from the raw data without having to reorganise it as shown in Table 2 in 'Data' sheet on attached Example file.
There is lots of data (not shown in Example) so need to avoid reorganising the raw data.
Any suggestions how to do this.