I have a list in a column of Regions. The elements subregions or sub-subregions are identified by "-". There may be one or more levels per region.
I would like to create a column of "Hierarchy of regions", so the "level above being the parent" will show.
The elements are always sorted, so no e.g. row of Europe-England when listing African regions.
Preferably by using "basic formula" in Excel or Power Query.
I would like to create a column of "Hierarchy of regions", so the "level above being the parent" will show.
The elements are always sorted, so no e.g. row of Europe-England when listing African regions.
Preferably by using "basic formula" in Excel or Power Query.