I've come this far: Test.xlsx
But I can't explode the subparts. Tricky part is SubPart2 also includes SubPart3.
Well, it's 4 am here and I am like :banghead::banghead::banghead: I've tried every single relationship combination. Every Column and row combination but no way...