I got the following tree structure.
I have a repeater on Podcast page and need to display the latest sibiling document name on each item on the repeater. So for example, I will have the following in the repeater
MHPN Presents Ageing Well - Latest: Episod 1
MHPN Presents Trauma and Resilience - Latest: Trauma and Resilience: Trauma, a history

You could use
webpartwithin the transformation. Something like that could do what you want. You have to change theClassNames,SiteName,TransformationNamewith the one you want. ThisOrderBywill display the first on the tree. You can change it accordingly if you want something else.You can have a similar results using a Hierarchical viewer as well. However, since you require only one sibling you cannot do it that easily.
You can find an example at xperience and kentico
There might be small differences depending on the Kentico version you are using.
Dimitris