Always fun to solve using Spatial Tools.
Solved it differently using Multi-Row Formula Tool and Cross Tab.
The solving thrill continues!!!!!!!!!!!!!!!!
Regards,
Yugandhar Muley (Yug)
Alteryx ACE | Alteryx For Good India Lead | Bengaluru Alteryx User Group Lead