How to Organize Dated Info into the Correct Columns with Formulas

I'm on a deadline to finish this project and can't figure out how to organize the info.
If anyone can help, I'd really appreciate it.

I've attached the basic spreadsheet of what I'm trying to do here:
ExelForumFixTest.xlsx

I've included a "notes" sheet of exactly what I'm trying to do.
There are 2 other sheets: "IBM" and "FB".

The IBM and FB sheets have stock data that includes annual and sometimes quarterly data.
I want to take this mixed annual and quarterly data from range (C8:M8) and re-organize it into the range (AA8:AK8).
I've manually organized it correctly, as you can see in range (AA8:AK8), but I need this to happen automatically with formulas in each sheet.

After organizing, it should show the annual data in the correct columns, but it should no longer show the quarterly data.

Thank you so much for any help you can offer.
It's drivin me nuts!