Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Displaying Excel data in flattened hierarchy
What do you mean by a flattened hierachy? As in all the ten numbers/codes
being joined together? "Nagesh" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to filter only the first level in the hierarchy | Excel Discussion (Misc queries) | |||
Need ActiveX hierarchy. | Excel Discussion (Misc queries) | |||
Hierarchy in excel | Excel Discussion (Misc queries) | |||
Hierarchy in excel | New Users to Excel | |||
SUMPRODUCT - HIERARCHY | Excel Worksheet Functions |