Has anyone broken out a tree into different levels to sort link in excel etc? Here is the tree that I want to breakout into columns for sorting/linking, etc. I love the tree for presentation but I don't have access to the source data and I need this info to link to get other related data from other systems.
I have text in a column that I would like to separate the levels. Each level is indented 5 spaces. The highest level is below the lower levels and has 5 spaces in front of it and the lowest level has 25 spaces. The lowest level is always on top and the highest is on the bottom.
This can cycle through a few times till it hits ENTITYWIDE with No spaces. There can be many APUnits within a Budget Activity. There can be many budget activities within a budget program. There can be many Agncies within a Dept. There is only one EntityWide.
Can I get the columns to read up and put in column A the dept, B the agency, C Bud Prog, D Bud Act, E AP unit and have it fill in the columns so that all of the AP units have a tree so that I can sort in excel.
Right now I can not sort or do anything with the info even though the hiearchy is obvious. Has anyone done something similiar with code? Any ideas?