Hello

I have one column like this:

Asset\US\CA\SF
Asset\US\Phil
Asset\UK\London
Asset\UK\Glasgow
Asset\India\MH\Mumbai\Andheri
Asset\Canada


There are hundreds of such entries. I want to create hierarchy of these
items. Means i want Asset at the top then US, UK, India etc as its children
and so on. How can I achieve this in excel?

Thank you in advance

Regards
prm