I was planning to have a dropdown of quarterly and annually, such that if I select quarterly, then the detail shows up. if i select annually, then the detailed quartelry columns hide and only annual columns shows up.
A different path to take would be to have the columns with actual data on a separate sheet, and then on the main sheet, you've got formulas setup to pull either the annual info, or the monthly info, depending on dropdown.