Creating hierarchy in excel
 

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

Creating hierarchy in excel
 

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?

"Pawan" wrote:

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

Creating hierarchy in excel
 

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.

"Atishoo" wrote:

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?

"Pawan" wrote:

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

Creating hierarchy in excel
 

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)

Pawan wrote:

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.

"Atishoo" wrote:

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?

"Pawan" wrote:

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

--

Dave Peterson