Well, yes - if the "transformation step" is reorganizing your data.
With unique names (which are necessary), your example structure corresponds to
This data has to be reorganized into two columns as follows:
The first row is optional (depending on whether or not you have "Property Names in First Row" enabled). The order of the remaining rows does not matter. With "Layout" set to "Hierarchical", this data will result in the following diagram:
Edit: Removed duplicate row.