@jaeW_at_Onyx this is probably right up your alley with recent Dojo solutions and videos you have put together. Please see my video linked below, and attached sample data.
https://youtu.be/Y21fV4t5kGk
I have been able to do this with an ETL so for those that want to know how that is included in the video. I would prefer to do this with a beast mode as my current data set is massive and the ETL takes a while to run.