I have an excel budget table with account numbers as rows and period dates as columns. I want to convert the table so that there are 12 rows for each of the 1100 account numbers. Column A would be the Account Number, Column B the Period Ending Date and Column C the budgeted value for that account and period. If the period value is blank, the value would be zero.
Is there an easy way to do this via VBA?