View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Commish Commish is offline
external usenet poster
 
Posts: 14
Default Tree from Parent/Child Pairs

I have a list of organizations in 2 columns - parent in column A, child in column B.

It could look like this:
A B
B C
B D
C E
D F
F G
and so on.

Is there an easy-ish way to convert this to a list of unique branches? Where the result would look like:
A B
A B C
A B C E
A B D
A B D F
A B D F G

Any thoughts?