Of course, I'm hoping that there is some clever bit of XSLT trickery
that I've missed (but I'm not optimistic).

There could well be... maybe provide some small sample inputs and the
required outputs - much better than long winded wordy questions.