September 14th, 2012, 2:32 pm
QuoteOriginally posted by: outrunI have a spreadsheet with the definition of a tree.Each node in the tree is a row in a table with these columns:* node_id* parent_node_id* distance_to_root* descriptionHow can I get a visual representation of the tree, prefereable like a directory structure, and prefreable without VBA, -eg. using a pivot table-? EDIT:Solved it at the Oracle backend with the START WITH and CONNECT BY hierachical SQL language extension. Nice of Oracle to provide that type of query functionality!did you write a script based on the hierachical SQL language extension to build a tree outside of Excel ?