Option One - Embedded data, can be shown as read only - so you can still use this type and still can use repeating view.
@Kamil_Janeczek goes through this solution in great detail in this Constellation 101
Option Two - List view/Insights I would be looking at a solution along the lines of @JayachandraSiddipeta’s suggestion. Using Insights or List Views - they give you a little more flexibility than perhaps the query field is giving you.
- List Views can use gallery, but gallery can’t go multiple levels
- However, both List Views and Insights can do multiple levels of groupings, which can turn flat data into something more hierarchical
These “report” options, have added benefits like searching and personalised views, which give flexibility to users depending on the “why” behind the need to show so many addresses and so many levels all at once (can get confusing)
Option Three - Case Hierarchy widget Infinity ‘25 introduced a case hierarchy widget. I don’t know the requirements behind showing all the addresses, personally I think option two is the most flexible but would be remiss to mention this option as viable. You can use this, along with Preview, to show a lot more data about each level. So depending on the “why” this might be a preferrable business outcome. I don’t have a screenshot of the widget + preview to hand, but it would work much the same as this example.
@PierreM17643706 has a great write up in our Constellation 101 series on this