Transform hierarchy JSON to flat Excel

Hello v-cherch-msft ,

Thank you for your post. I decided to move the data to the database as it is more natural to me. Then I was able to create the following table:

But I would like to have lit like this:

Can you please advice how to do that? All the guides I found finished with a full table with all values in place, but I need all values there just once and in this hierarchical structure. And even better... Would be possible to indent each level like this?

I found e.g.:

- https://community.powerbi.com/t5/Desktop/Adding-indentation-and-hierarchy-to-a-list-of-project-tasks/m-p/441331#M203781

- https://community.powerbi.com/t5/Desktop/show-grand-totals-top-bottom-of-matrix/m-p/408946#M187480

But it is done for just one column (and inside) and not for a set of columns.

I have another idea... I can concatenate data from each table to one column:

But In this case, I need it with the intent...

Can you please advise which way would be better?

Thank you

Ondrej