Creating hierarchy in excel

  • Thread starter Thread starter Pawan
  • Start date Start date
P

Pawan

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
 
So are you wanting to push each text string devided by a \ over to the next
column and then delete all reptitions of any text string down these columns?
 
Somewhat like that. I want Assets in first column, then only one entry for US
in second column and then all children of US in the next column. No
repetitions required.
 
First, I'd use data|text to columns
Choose delimited by slash
and finish up that wizard.

But I wouldn't delete the duplicate entries. I find that I'll want them later
(sorting/filtering/charting...)

Instead, I'd hide the duplicates using conditional formatting.
http://contextures.com/xlCondFormat03.html#Duplicate
(from Debra Dalgleish's site)
 
Back
Top