Combine data from multiple cells if another cell contains...

Hello,

I am trying to sync a table's data with a timeline I am building.

Attached is an Example doc for what i'm trying to accomplish.

My goal is to take the data from the left table and sync it with the timeline. The hope is that I only have to modify data in the table, hit a button, and all of that data will correspond to the timeline with color coordination and spacing based on what quarter it is.

Is this wishful thinking, or is there a way to accomplish this?

Thanks for the insight!