Organizing product name hierarchy in good overview

[Fazniro]

Hello there

I have this long list of product names with different hierarchies that i have named, but i am unsure if i have named them all correctly. So i am trying to find a way to easily organize them so i can see if i made a mistake.

please see the following google sheet, where the problem is more intuitively understood.

https://docs.google.com/spreadsheet...KQmchyjsJKpIWCELptqYkOc2YE/edit#gid=330914579

The list of each product name is about 200-300 per level, so manually organizing them would take a long time.

Would love your input if there is some smart way to do it.

best regards
Jakob

 

[Fazniro]

Hey again.

Hope someone could help me with this issue as it would mean the world to me and make my life at work a lot easier.

Please see link: https://docs.google.com/spreadsheet...KQmchyjsJKpIWCELptqYkOc2YE/edit#gid=330914579

If my idea cant be done, then i am curious if there is some other way to organize the product hierachy names in order to inspect if the names are build correctly.

best regards
Jakob