Hey,
So I have several large budget tables like below with the months going through to December.
GLCode GLCode-Description Location Category Jan Feb Etc… Dec 450-01 Salaries 1 A 50,5 50,5 Etc… 505 450-03 Hourly Labor 1 A 505 505 Etc… 505
I am going to be taking over some monthly Actual vs Budget reporting and would like to automate it by connecting the budget to our SQL database. I was wondering if there was a way to transpose the monthly data while somehow linking it to the GL Code. There are a couples way I can think to do it manually just wanted to check and see if there was an easier way.
Thanks for any advice.