I have a hard one.

I work for a government institution with a lot of bureocratic hierarchies. We´ve recently made a survey of over 6000 locations.
For each of these locations there will be created lots of columns of data. 6 of them will define hierarchy.
Each of those six columns may individually repeat names (for example "maintenance" but relates to different buildings)
It conforms a quite large and complex tree with many repetitions

An example I´ve seen around illustrates this well:

Continents Countries Cities Streetname Shopname Foodtype... etc

It´s basically the same kind of structure where many repetitions will occur

We´ll now start the phase of passing our survey into excel and I´d like to create restricted and auto-filtering lists for each of those columns.
That way, once you choose the continent from the first validated list, the second one shows only the corresponding countries and so on.

The thing is, I´ve seen this done by creating several tables as a source for those lists, but being my database so complex, it´s just not worth it, it would take forever.
I was hoping for a function that can do this automatically.

The source for this is a table in this manner:

HIER1 HIER2 HIER3
America USA New York
America USA Washington
America Venezuela Santa Maria
Europe Spain Santa Maria
Europe France Paris

And so on for 6 related columns....

Is this doable at all?

Thanks a lot!