View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nagesh Nagesh is offline
external usenet poster
 
Posts: 11
Default Displaying Excel data in flattened hierarchy

Hi,

I have data in two columns. First one has child code and second one has its
parent code. All these entries could be running into about 10 levels in
hierarchy.

Is there a way I can show this data in flattened hierarchy in the same
sheet? I know some crude way of doing it but looking for clean way of doing
this exercise.

Thanks for the help.
Nag