I am trying to review the budget for our department at work, but it is an insane amount of data that is organised as followed:
I am trying to use a pivot table to see the changes per month for each cost center, but I can't get Excel to do this for me. I would like to plot to this in a graph like this:
I am using office 365 excel with windows 10.
un pivotthe data, will write up a full answer when I have time