Hi @Paul_Bettner,
welcome to this Community! 
I guess your use case has lots of similarities with @Steve_Yang’s one: How to write formula for turn outline view into Table view?
There is still not a perfect solution, but you can find some useful approaches in the thread.
I hope this helps.