+ Reply to Thread
Results 1 to 4 of 4

tree structure output

  1. #1
    Registered User
    Join Date
    08-02-2007
    Posts
    3

    tree structure output

    Hi,

    I have series of columns with difference entries

    col 1 : parent names list
    col 2 : children name list
    col 3 : children of col 2
    col 4 : children of col 3

    i want to organise in such a way that i can see a tree like structure

    col1
    col2(child1)
    col3(child1)
    col2 child2
    col3(child2)
    col2 child3
    .
    .
    .
    .

    is it possible to bring it in excel..

    Pls help

  2. #2
    Forum Contributor
    Join Date
    03-14-2006
    Location
    Pakistan
    Posts
    1,791

    Lightbulb

    Hi
    You should provide a sample file of Excel in .zip format for better consideration.

  3. #3
    Registered User
    Join Date
    08-02-2007
    Posts
    3

    attachment

    I am not able to attach the file..

    col1 col2 col3 col4
    x a 1 i
    x b 2 i
    x b 2 j
    y f 3 k
    y c 5
    y x a
    y e e
    z g 7
    z h 7
    z y 8
    z x 8

  4. #4
    Registered User
    Join Date
    04-15-2004
    Posts
    30
    You can use Data -> Group feature but it goes to only 5 levels down.
    Try it.

    I want to know if we can go more than 5 levels.

    NYBoy

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1