Hi,

I have series of columns with difference entries

col 1 : parent names list
col 2 : children name list
col 3 : children of col 2
col 4 : children of col 3

i want to organise in such a way that i can see a tree like structure

col1
col2(child1)
col3(child1)
col2 child2
col3(child2)
col2 child3
.
.
.
.

is it possible to bring it in excel..

Pls help